topic Re: Performance SQL - Indexing in Application Development and Automation Discussions

Performance SQL - Indexing

Former Member — Tue, 26 Jun 2007 14:33:29 GMT

Hi Experts,

I hv 2 different SQLs in same prog., like,

<i>SELECT DISTINCT bname

INTO TABLE bname_itab

FROM vbak

WHERE ernam IN s_ernam

AND bname NE space

AND auart IN s_auart

AND vkorg IN s_org

AND vtweg IN s_d_ch

AND spart IN s_div.</i>

SELECT vbeln into vbeln_itab

from vbak

where kunnr = s_kunnr

and kvgr2 = kvgr2.

So,

Already I hv one secondary index as Z02 for ernamauartvkorgvtwegspart

So, (performance point of view)

1 - Shuld I add kuunr + kvgr2 to the existing Z02 index?

2 - OR shalll I create a new one as Z03 with kunnr + kvgr2?

thanq.

Former Member — Tue, 26 Jun 2007 15:56:19 GMT

Have you used the 'explain' function of ST05 to make sure that it is using the index for the first SELECT? The NE is going to cause problems.

Rob

Former Member — Tue, 26 Jun 2007 17:53:31 GMT

ThanQ Rob,

No, I did not see the EXPLAIN function, will go thru it.

But, pls. let me clarify that,

How the NE operator in bname NE space, creates a problem?

thanq.