INDEX_COMBINE

INDEX_COMBINE Hint

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 24th May 2022

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