First page Back Continue Last page Graphics

…Index Full Scan

Notes:

This example demonstrates CBO’s choice of an index full scan access path. Note that, because the table rows are returned via the index, a SORT step is not needed in the execution plan even though an ORDER BY is specified.
Note that since an index full scan does not read the actual table, the table is not a factor in the CBO cost calculation:
cost= blevel + (ff * leaf blocks)