Listing16 EXPLAIN PLAN FOR SELECT COUNT(*) FROM SALES_FORECAST_PR F, ACTUAL_SALES_PR S WHERE S.PART_ID = F.PART_ID AND S.SALE_DATE = F.FORECAST_DATE AND S.QUANTITY > F.QUANTITY; SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY); ------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost | Pstart| Pstop | ------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 1 | 26 | 3900 | | | | 1 | SORT AGGREGATE | | 1 | 26 | | | | | 2 | PARTITION RANGE ALL| | | | | 1 | 10 | |* 3 | HASH JOIN | | 182K| 4633K| 3900 | | | | 4 | TABLE ACCESS FULL| SALES_FORECAST_PR | 3650K| 45M| 1015 | 1 | 10 | | 5 | TABLE ACCESS FULL| ACTUAL_SALES_PR | 3650K| 45M| 1015 | 1 | 10 | -------------------------------------------------------------------------------------------