Hi
1.
DO
Begin
temp1 = select * from EKKO where BUKRS = '1000'.
select temp1.*, EKPO.* from temp1 inner join EKPO.
END;
2.
DO
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 ?
