Listing15 EXPLAIN PLAN FOR SELECT COUNT(*) FROM SALES_FORECAST F, ACTUAL_SALES 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 |TempSpc| Cost | -------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 1 | 26 | | 7697 | | 1 | SORT AGGREGATE | | 1 | 26 | | | |* 2 | HASH JOIN | | 182K| 4633K| 159M| 7697 | | 3 | TABLE ACCESS FULL | SALES_FORECAST | 3650K| 45M| | 1015 | | 4 | TABLE ACCESS FULL | ACTUAL_SALES | 3650K| 45M| | 1015 | --------------------------------------------------------------------------------