Specifies MRU cache strategy for the scan of a stored table.
( prop table_name ( mru) )
is the table to which the property is to be applied.
select * from t1
( prop t1 ( mru ) )
Specifies the use of MRU cache strategy for the table.
MRU strategy is specified in the resulting query plan
Partial plans can specify scan properties without specifying other portions of the query plan.
Generated query plans always include all scan properties.
If sp_cachestrategy has been used to disable MRU replacement for a table or index, and the query plan specifies MRU, the specification in the abstract plan is silently ignored.