INDEX_FFS AND NO_INDEX_FFS

Index_Fss Hint Description

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_Fss Hint Description

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 on 

Published 24th May 2022