Specifies properties to use for the scan of a stored table.
( prop table_name ( property_specification ) ... )
( prefetch size ) ( lru | mru ) ( parallel degree )
is the table to which the property is to be applied.
select * from t1
( t_scan t1 ) ( prop t1 ( parallel 1 ) ( prefetch 16 ) ( lru ) )
Shows the property values used by the scan of t1.
The specified properties are used for the scan of the table
Partial plans can specify scan properties without specifying other portions of the query plan.
Generated plans include the parallel, prefetch, and cache strategy properties used for each table in the query.
lru, mru, parallel, prefetch