Syntax options:

    CACHE SIZE IS n ROW | CACHE SIZE IS n ROWS

    Specifies the number of rows allocated to the row cache. As the
    row cache fills, rows more recently referenced are retained in
    the row cache while those not referenced recently are discarded.
    Adjusting the allocation of the row cache helps to retain
    important rows in memory. If not specified, the default is 1000
    rows.