Skip to Content
0
Former Member
Dec 03, 2008 at 06:02 AM

Issue with select statement which is not using index

279 Views

Hi,

SELECT vgbel

FROM vbak INTO TABLE t_order

FOR ALL ENTRIES IN t_contract

WHERE auart IN r_odrtyp

AND vgbel = t_contract-vbelv.

The above select statement is causing a performance issue because it is not using an index.If the index VBAK-AUD which is having AUDAT field is used in the where condition of the select statement the performance can be improve.

Is it feasible to use audat field in the where condition?By using this field in the where condition will filter the entries from vbak table still further?