topic Re: Expensive SQL Statement in Application Development and Automation Discussions

Expensive SQL Statement

Former Member — Mon, 19 Oct 2009 09:50:51 GMT

Hi Guys,

I have just received an email from our basis team where they said I am using an expensive SQL statement.

There is a loop on a table of people with the following statement

SELECT * FROM catsdb INTO TABLE w_cats

WHERE arbid EQ i_data-arbid

AND raufpl EQ i_data-aufpl

AND raplzl EQ i_data-aplzl

AND workdate IN s_wdate

AND status EQ '30'.

Is it me or is this the quickest way possible??

Can anyone think of a better way to do this??

Thanks Experts

Former Member — Mon, 19 Oct 2009 12:25:31 GMT

First of all, did you ever hear about indices? Please check whether there is an index (SE11) with has fields of your WHERE-condition.

=> if this is not the case the it will be slow, until an index is created.

Second, change the LOOP into a FOR ALL ENTRIES, don't forget to check whether the itab is initial.

ThomasZloch — Mon, 19 Oct 2009 12:41:49 GMT

Also

Thomas