First page Back Continue Last page Graphics

…Index Join Access Path

Notes:

Here we see CBO’s use of an index join access path. The database performs a range scan on the T1_OBJECT_ID index to get entries “BETWEEN 1 and 1000”, then a range scan on the T1_OBJECT_TYPE index to get entries where “object_type = ‘TABLE’. Then the database performs a hash join to produce a view of final results. (You will learn more about hash joins in the Join Methods lesson.)