Hi
I have the below select statement
Selec a~compcode a~profitcenter b~costcenter into table ztest
from /bic/zabc000 as A inner join /bic/def000 as B
ON A~compcode = b~compcode and A~profitcenter = b~profitcenter
for all entries in table xyz
where A~dateto >= sy-datum and B-costcenter = xyz-costcenter.
Here i have where clause on both table A and B. Table b is populated using table xyz entries.
Table A currently has more than 200000 records and table B also has the same.
How will be the performance of this select or is it better to select the data seperately from both table.
Thanks