SQL> explain plan for 2 SELECT ORDH_NO,ORDH_DATE,.... 10 ORDT_ITEM_EXCS_DTY,'BNG' FROM ORDRHEAD,ORDRDETL WHERE ORDH_NO = 11 ORDT_ORDH_NO AND ORDH_STATUS = 'Y' AND ORDH_NO in 12 (select ordh_no from ordrhead minus 13 SELECT ORDH_NO FROM PS_ORDH_CNTL ); Plan Table -------------------------------------------------------------------------------- | Operation | Name | Rows | Bytes| Cost | Pstart| Pstop | -------------------------------------------------------------------------------- | SELECT STATEMENT | | 17K| 3M| 14 | | | | HASH JOIN | | 17K| 3M| 14 | | | | NESTED LOOPS | | 21 | 4K| 2 | | | | TABLE ACCESS FULL |ORDRHEAD | 1 | 159 | 1 | | | | TABLE ACCESS FULL |ORDRDETL | 41 | 1K| 1 | | | | VIEW | | 1K| 20K| 11 | | | | MINUS | | | | | | | | SORT UNIQUE | | 2 | 26 | 3 | | | | INDEX FULL SCAN |PK_ORDRHE | 2 | 26 | 1 | | | | SORT UNIQUE | | 1K| 20K| 8 | | | | TABLE ACCESS FULL |PS_ORDH_C | 1K| 20K| 1 | | | -------------------------------------------------------------------------------- SQL> explain plan for 2 SELECT COUNT(*) FROM ORDRHEAD,ORDRDETL WHERE ORDH_NO = 3 ORDT_ORDH_NO AND ORDH_STATUS = 'Y' AND ORDH_NO in 4 (select ordh_no from ordrhead minus 5 SELECT ORDH_NO FROM PS_ORDH_CNTL ); Plan Table -------------------------------------------------------------------------------- | Operation | Name | Rows | Bytes| Cost | Pstart| Pstop | -------------------------------------------------------------------------------- | SELECT STATEMENT | | 1 | 905K| 14 | | | | SORT AGGREGATE | | 1 | 905K| | | | | HASH JOIN | | 17K| 905K| 14 | | | | NESTED LOOPS | | 21 | 861 | 2 | | | | TABLE ACCESS FULL |ORDRHEAD | 1 | 28 | 1 | | | | INDEX RANGE SCAN |PK_ORDRDE | 41 | 533 | 1 | | | | VIEW | | 1K| 20K| 11 | | | | MINUS | | | | | | | | SORT UNIQUE | | 2 | 26 | 3 | | | | INDEX FULL SCAN |PK_ORDRHE | 2 | 26 | 1 | | | | SORT UNIQUE | | 1K| 20K| 8 | | | | TABLE ACCESS FULL |PS_ORDH_C | 1K| 20K| 1 | | | --------------------------------------------------------------------------------