In select, delete, and update statements

You can use lru or mru in a select, delete, or update command to specify the I/O size for the query. (You get only sizes based on caches you have configured correctly. For example, if you specify 4K but Adaptive Server does not use a 4K page size, the command returns 2K):

select select_list
      from table_name
           (index index_name prefetch size [lru|mru])
           [, table_name ...]
where ...

delete table_name from table_name (index index_name 
      prefetch size [lru|mru]) ... 

update table_name set col_name = value
      from table_name (index index_name
             prefetch size [lru|mru]) ...

For example, to add the LRU replacement strategy to a 16K I/O specification, enter:

select au_lname, au_fname, phone
    from authors (index au_names prefetch 16 lru)