First page Back Continue Last page Graphics

…Index Skip Scan

Given:
Then:

Notes:

This example illustrates the benefit of the Oracle9i SKIP SCAN index technique. A query that does not include the leading, high order column of an index can now use that index to reduce query processing time.
Query the OPERATION and OPTIONS columns of the PLAN_TABLE to see if SKIP SCAN is used:
OPERATION = INDEX, OPTIONS = SKIP SCAN
See the supplied script SKIPSCAN.SQL for a working example of the skip scan access path.

…Index Skip Scan

Given:

Then:

Notes: