Operation Object Name Rows Bytes Cost Object Node In/Out PStart PStop SELECT STATEMENT Optimizer Mode=CHOOSE 501 K 19321 MERGE JOIN 501 K 60 M 19321 MERGE JOIN 501 K 38 M 13181 TABLE ACCESS BY INDEX ROWID D_SMF.SMF_INSTR_NAMES 1 M 21 M 3218 INDEX FULL SCAN D_SMF.SMF_INAM_PK 1 M 2590 SORT JOIN 492 K 29 M 7968 TABLE ACCESS FULL D_SMF.SMF_NAMES_DENORM_IBS 492 K 29 M 1995 FILTER SORT JOIN TABLE ACCESS FULL D_SMF.SMF_ISTN_NAMES 376 K 16 M 1356