ID PARENT_ID OPERATION
--------------------------------------- --------------------------------------- -----------------------------------------
0 SELECT STATEMENT
1 0 HASH JOIN OUTER
2 1 TABLE ACCESS BY INDEX ROWID TABLE1
3 2 INDEX RANGE SCAN INDEX_TABLE1_ID