Explain plan for View query Operation Object Name Rows Bytes Cost Object Node In/Out PStart PStop SELECT STATEMENT Optimizer Mode=ALL_ROWS 1M 1164 5 UNION-ALL CONCATENATION HASH JOIN 93K 7M 4639 [u][i][b]TABLE ACCESS FULL FCCI_PROD.POLICY_REGISTER[/b][/i][/u] 67K 2M 706 TABLE ACCESS BY INDEX ROWID FCCI_PROD.ENTITY_ADDRESS_MASTER 155K 7M 3330 INDEX SKIP SCAN [i][b]FCCI_PROD.I_EAM_IND6[/b][/i] 155K 807 HASH JOIN 1M 98M 1695 TABLE ACCESS BY INDEX ROWID FCCI_PROD.ENTITY_ADDRESS_MASTER 10K 514K 981 INDEX SKIP SCAN [b][i]FCCI_PROD.I_EAM_IND6[/i][/b] 10K 807 [u][i][b]TABLE ACCESS FULL FCCI_PROD.POLICY_REGISTER[/b][/i][/u] 67K 2M 706 HASH JOIN 17K 1M 5310 TABLE ACCESS BY INDEX ROWID FCCI_PROD.POLICY_ENTITY_REGISTER 2 70 1 NESTED LOOPS 126K 6M 159 INDEX FULL SCAN FCCI_PROD.UK_PREG 67K 1M 57 INDEX RANGE SCAN FCCI_PROD.IND_PER_1 1 1 TABLE ACCESS BY INDEX ROWID FCCI_PROD.ENTITY_ADDRESS_MASTER 207K 9M 4171 INDEX SKIP SCAN [i][b]FCCI_PROD.I_EAM_IND6[/b][/i] 207K 807