INDEX_FFS and NO_INDEX_FFS

INDEX_FFS Hint

The INDEX_FFS hint forces Oracle to perform a fast full index scan rather than a full table scan.

Each parameter serves the same purpose as in INDEX Hint.

Example

SELECT /*+ INDEX_FFS(a myIndex1) */ col1
  FROM myTable1 a
/

NO_INDEX_FFS Hint

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

Example

SELECT /*+ NO_INDEX_FFS(myTable1 myIndex1) */ col1
  FROM myTabke1
/

Published 24th May 2022

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License