INDEX_COMBINE

Index_Combine Hint Description

The INDEX_COMBINE hint can use any type of index: bitmap, b-tree, or domain. If you do not specify indexspec in the INDEX_COMBINE hint, the optimizer implicitly applies the INDEX hint to all indexes, using as many indexes as possible. If you specify indexspec, then the optimizer uses all the hinted indexes that are legal and valid to use, regardless of cost. Each parameter serves the same purpose as in INDEX Hint.

Example

SELECT /*+ INDEX_COMBINE(a myIndex1 myIndex2) */ *

  FROM myTab1 a

  WHERE col1 = 'FRED'

     OR col2 = 'SMITH'

/

Published on 

Published 24th May 2022