issue in select query

former_member97974 — Sun, 11 Oct 2009 19:03:36 GMT

HI All experts,

i have a program in which i have a select query

SELECT b~vertrag

a~anlage

a~operand

a~saison

a~ab

a~ablfdnr

a~bis

a~wert1

FROM ettifn AS a INNER JOIN ever AS b

ON a_{anlage = b}anlage

INTO TABLE li_captran PACKAGE SIZE p_pack

WHERE a~anlage IN s_anlage

AND a~ab <= l_date

AND a~bis >= l_date

AND a~operand IN ('ID-CAPLOAD','ID-OBLT')

AND b~einzdat <= l_date

AND b~auszdat >= l_date.

this query is taking a lot of time in running and we are facing lot of performance related issues

kindly guide me how i can break this into som simpler query

ettifn has 10 million records

ever has around 5 million records .

also please tell me how much data i can store into an internal table

can i store 5 million records in an internal table ??????

is it good in terms of performance of a program if not please tell me what is the better way of doing dat .

also tell me how secondry indexes help in improving performance of select query

is it good to maintain number of secondry indexes in a standard table or it decreases performance of a standard table .

please guide me how can i increase the performance of this code .

Thanks in advance

Re: issue in select query

daixiong_jiang3 — Mon, 12 Oct 2009 02:47:12 GMT

I think the following articles may help you:

[Performance Tuning Using RFC|http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/0076258e-41dd-2a10-9a82-cf5e9f5cd77c]