Was this helpful?
MODIFY...TO PRIORITY=n
Syntax to assign a table fixed cache priority:
MODIFY tablename TO PRIORITY = cache_priority
This MODIFY statement permits the assignment of a cache priority without having to also change the storage structure. This must be an integer between 0 and 8, with 0 being the lowest priority and 8 being the highest. A specification of 0 causes the table to revert to a normal cache management algorithm and is the default value. If an explicit priority is not set for an index belonging to a base table to which an explicit priority has been assigned, the index inherits the priority of the base table.
Last modified date: 11/28/2023