Skip to Content
0
Aug 05, 2016 at 12:21 PM

Inner Join Performance

35 Views

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