topic Re: Select Statement performance in Application Development and Automation Discussions

Select Statement performance

Former Member — Mon, 16 Oct 2006 07:21:59 GMT

SELECT * FROM CATSPS INTO TABLE TCATSPS

WHERE TRANSFER = 'X' .

SELECT RUECK

CATSBELNR

STOKZ

FROM AFRU

INTO table T_AFRU

for all entries in tcatsps

WHERE CATSBELNR = TCATSPS-BELNR

AND STOKZ = TCATSPS-STOKZ.

In the above statement, Tcatsps internal table is getting around 3 Lakh records. Becos of which when i run the select statement, time is taken for ever.

Can I improve the performance statment of above select statemtn in any other effective way.

Thanks

Regds

Venu

Re: Select Statement performance

Former Member — Mon, 16 Oct 2006 07:26:20 GMT

hi Venu,

1. Put all the entries order IN T_AFRU i.e, the way they are in the database table ..

2. Try including all the primary keys in the where condition of your select statement ..

3. Avoid using * instead fetch the required fields only ..

this way you can improve the performance of your program

Regards,

Santosh

Re: Select Statement performance

Former Member — Mon, 16 Oct 2006 07:30:51 GMT

Hi Saamy,

Instead of * specify require fields only...

In where condition specify all Primary keys and Secondary indexes...

If helpful reward..

Regards,

Kishore Reddy Vuppuluri.

Re: Select Statement performance

Former Member — Mon, 16 Oct 2006 07:50:53 GMT

Hi Venu,

From your code i could see that u have totally ignored the Primary keys.

Try to give counter and stokz feilds of CATSPS in ranges and the RUECK and RMZHL feilds of AFRU in ranges.

Dont use select * from catsps.

Reward if it helps.

Thanks,

Anooop

Re: Select Statement performance

Former Member — Mon, 16 Oct 2006 09:26:25 GMT

Hi,

the problem is first select statement is wotking fione. the time is taken for second select statement. and i couldnt use primary keys... cos condition i need doesnt depend on promary keys.

regds

Venu

Re: Select Statement performance

Former Member — Wed, 31 Jan 2007 11:57:57 GMT

define secondary indexes on the fields using which you are writing the select statement.

Re: Select Statement performance

Former Member — Tue, 06 Mar 2007 14:54:55 GMT

Yes, Use Secondary Index as well as Inner Join.

Thx

SAP Developer