topic Re: INDEX in Application Development and Automation Discussions

INDEX

Former Member — Fri, 01 Feb 2008 05:01:04 GMT

Plz find my SELECT query below:

select w~mandt

w_{vbeln w}posnr w_{meins w}matnr w_{werks w}netwr

w_{kwmeng w}vrkme w_{matwa w}charg w~pstyv

w_{posar w}prodh w_{grkor w}antlf w_{kztlf w}lprio

w_{vstel w}route w_{umvkz w}umvkn w_{abgru w}untto

w_{awahr w}erdat w_{erzet w}fixmg w_{prctr w}vpmat

w_{vpwrk w}mvgr1 w_{mvgr2 w}mvgr3 w_{mvgr4 w}mvgr5

w_{bedae w}cuobj w~mtvfp

x_{etenr x}wmeng x_{bmeng x}ettyp x_{wepos x}abart

x~edatu

x_{tddat x}mbdat x_{lddat x}wadat x_{abruf x}etart

x~ezeit

into table t_vbap

from vbap as w

inner join vbep as x on x_{vbeln = w}vbeln and

x_{posnr = w}posnr and

x_{mandt = w}mandt

for all entries in t_vbak

where

w~vbeln in s_ordno and

w~vbeln = t_vbak-vbeln and

( ( w_{erdat > pre_dat ) and ( w}erdat <= w_date ) ) and

( ( ( erdat > pre_dat and erdat < p_syndt ) or

( erdat = p_syndt and erzet <= p_syntm ) ) ) and

w~matnr in s_matnr and

w~pstyv in s_itmcat and

w~lfrel in s_lfrel and

w~abgru = ' ' and

w~kwmeng > 0 and

w~mtvfp in w_mtvfp and

x~ettyp in w_ettyp and

x~bdart in s_req_tp and

x~plart in s_pln_tp and

x~etart in s_etart and

x~abart in s_abart and

( ( x_{lifsp in s_lifsp ) or ( x}lifsp = ' ' ) ).

Could u please suggest an Index that can reduce the DB Access time for the above Query?

On what fields I should specify the Index

Thx

Re: INDEX

Former Member — Fri, 01 Feb 2008 05:04:18 GMT

Hi,

If u have check the where contion without primary key u may create index. that is called the secondary index.

Regards,

S.Nehru.

Re: INDEX

Former Member — Fri, 01 Feb 2008 05:14:17 GMT

instead of using joins between vbap and vbep

fecth VBAP entries for all the selected entries in VBAK

and then fecth VBEP entries for all the selected entires in VBAP. Then club both vbap and vbep entires into single internal table.

Re: INDEX

Former Member — Fri, 01 Feb 2008 05:17:57 GMT

Understand My QUERY plz!

Re: INDEX

Former Member — Fri, 01 Feb 2008 05:18:14 GMT

Understand My QUERY plz!

Re: INDEX

Former Member — Wed, 06 Feb 2008 08:50:28 GMT

No useful answers!

Re: INDEX

Former Member — Wed, 06 Feb 2008 08:56:08 GMT

Hi Santo,

I understand that your VBAP table is w in the query.

Now try creating a secondary index for VBAP.

Go to se11 and create index for VBAP in the order of your query. This will surely speed up DB access.

On what fields I should specify the Index?

maintain the same query sequence.

Edited by: rohitaash sharma on Feb 6, 2008 9:56 AM