topic Re: sql performance in Application Development and Automation Discussions

sql performance

former_member435389 — Tue, 22 Mar 2022 08:37:37 GMT

Begin

temp1 = select * from EKKO where BUKRS = '1000'.

select temp1.*, EKPO.* from temp1 inner join EKPO.

END;

Begin

select EKKO.*, EKPO.* from EKKO inner join EKPO where EKKO.BUKRS = '1000'.

END;

Which cost less time ?

I mean, two ways:

1. Firstly , reduce the result of table. and make join of tables.

2. Put the filter directly into the where clause of join.

Which way is better ?

Jrg_Brandeis — Tue, 22 Mar 2022 19:38:41 GMT

Hi Wei,

I am pretty sure, that both queries have the exact same execution plan. So the choice is up to you.

You can check this with the PlanViz tool.

Reards,

Jörg

former_member435389 — Wed, 23 Mar 2022 04:19:49 GMT

So it means these two kinds of SQL cost the same running time , am i right ?