Specifies the scan of a stored table, without specifying the type of scan.
( scan stored_table )
is the name of the stored table to be scanned. It can be a base table or worktable.
A derived table produced by the scan of the stored table.
select * from t1 where c11 > 10
( scan t1 )
Specifies a scan of t1, leaving the optimizer to choose whether to perform a table scan or index scan.
select *
from t1, t2
where c11 = 0
and c22 = 1000
and c12 = c21
( nl_g_join
( scan t2 )
( i_scan i_c22 t1 )
)
Specifies a partial plan, indicating the join order, but allowing the optimizer to choose the access method for t2.
The optimizer chooses the access method for the stored table.
The scan operator is used when the choice of the type of scan should be left to the optimizer. The resulting access method can be one of the following:
A full table scan
An index scan, with access to data pages
A covering index scan, with no access to data pages
A RID scan, used for the OR strategy
For an example of an abstract plan that specifies the reformatting strategy, see store.
