Skip to Content
0
Former Member
Aug 08, 2005 at 04:29 AM

Query Optimisation

25 Views

hello,

i have the following query which takes lot of time to fetch the data, which makes my Report very slow, can nyone help me to optimise this query if possible.

**************************************************

SELECT aarbpl aobjid bile01 bile02 bile03 bile04

bile05 bile06 bism01 bism02 bism03 bism04

bism05 bism06

INTO CORRESPONDING FIELDS OF TABLE i_act

FROM crhd AS a

INNER JOIN afru AS b ON

barbid = aobjid

WHERE a~arbpl IN s_arbpl AND

a~werks = p_werks AND

b~budat = p_budat AND

b~stokz <> 'X' AND

b~stzhl = '' .

my <i>s_arbpl contains fixed 12 values</i> only not more than that.

**************************************************

thanx

abhishek suppal