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