First page Back Continue Last page Graphics
Index Join Access Path…
Available when multiple indexes on one table
All data needed contained in indexes
Table not accessed
Process
- Retrieve matching entries from one index
- Retrieve matching entries from a second index
- Join results together
If CBO doesn’t choose, and you want to try
Notes:
The index join path access multiple indexes to collect the data required from the table (without table access) and joins the results together.