INDEX_SS and NO_INDEX_SS

INDEX_SS

The INDEX_SS hint forces Oracle to perform an index skip scan for the specified table. If the statement uses an index range scan, then Oracle scans the index entries in ascending order of their indexed values. In a partitioned index, the results are in ascending order within each partition.

Each parameter serves the same purpose as in INDEX Hint.

Example

SELECT /*+ INDEX_SS(a myIndex1) */ col1
  FROM myTable1 a
  WHERE col1 = 'FRED'
/

NO_INDEX_SS

The NO_INDEX_SS hint forces Oracle to exclude a skip scan of the specified indexes on the specified table. Each parameter serves the same purpose as in the NO_INDEX Hint.

---

Published 24th May 2022