The next example shows how to set the residency status of an entire table:
SET TABLE tab1 MEMORY_RESIDENT
For fragmented tables or indexes, you can specify residency for individual fragments as the following example shows:
SET INDEX index1 (dbspace1, dbspace2) MEMORY_RESIDENT; SET TABLE tab1 (dbspace1) NON_RESIDENT
This example specifies that the tab1 fragment in dbspace1 is not to remain in shared memory while the index1 fragments in dbspace1 and dbspace2 are to remain in shared memory as long as possible.
Related statement: ALTER FRAGMENT
For information on how to monitor the residency status of tables, indexes, and fragments, refer to your IBM Informix Administrator's Guide.