Experts,
Here is the query:
SELECT * FROM "SCHEMA"."SALES_FLAT" A,
"SCHEMA"."SALES_FLAT_TARGET" B
WHERE A.SALESORDER = B.SALESORDER
AND A.SALESORDER >= 10004
AND B.SALESORDER >= 10004;
Table A has a total of 17 rows and 10 after the filter.
Table B has a total of 34 rows and 20 after the filter.
I get 88 rows when I run the query. When I do an explain plan - right-click on the highlighted query and click on Explain Plan, the output size returns 69.14. I do not see 88 anywhere in the output size column. Shouldn't I see it?
Please suggest what might be the issue.
Thanks.
Shahid