INDEX_JOIN

Index_Join Hint Description

The INDEX_JOIN hint instructs the optimizer to use an index join as an access path. For the hint to have a positive effect, a sufficiently small number of indexes must exist that contain all the columns required to resolve the query.

Each parameter serves the same purpose as in INDEX Hint. For example, the following query uses an index join to access the col1 and col2 columns, both of which are indexed in the myTab1 table.

Example

SELECT /*+ INDEX_JOIN(a myIndex1 myIndex2) */ col1

  FROM myTab1 a

  WHERE col2 < 200

    AND col1 < 10

/

Published on 

Published 24th May 2022