Skip to Content
0
Jan 10, 2023 at 01:31 AM

HANA SQL Explain Plan

175 Views Last edit Jan 10, 2023 at 01:36 AM 2 rev

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