Specifies LRU cache strategy for the scan of a stored table.
( prop table_name ( lru ) )
is the table to which the property is to be applied.
select * from t1
( prop t1
( lru)
)
Specifies the use of LRU cache strategy for the scan of t1.
LRU strategy is used in the resulting query plan.
Partial plans can specify scan properties without specifying other portions of the query plan.
Full query plans always include all scan properties.
