INDEX_SS and NO_INDEX_SS
INDEX_SS and NO_INDEX_SS
Index_Ss Hint Description
Index_Ss Hint Description
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
Example
SELECT /*+ INDEX_SS(a myIndex1) */ col1
FROM myTable1 a
WHERE col1 = 'FRED'
/
NO_INDEX_SS
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 on
Published 24th May 2022