Once the MEMORY RESIDENT option is set for a structure, the buffers used by the structure stay in memory until the last user of a structure closes the database or until the MEMORY RESIDENT option is explicitly reset through the Visible DBS facility.

The COARSE option is meaningful only for an index sequential set; it means the coarse tables only are kept in memory.