Skip to Content
0
Former Member
Aug 08, 2011 at 07:40 AM

SELECT query - performance improvement needed

66 Views

HI guys.

can u help me to improve the performance of the following query.

Observations :

1. the index hit for the query correct(primary key).

2. removed duplicates from the internal table before calling

*Please let me know any other way we can improve this query.

SORT t_delno1 BY vbelv.

DELETE ADJACENT DUPLICATES FROM t_delno1 COMPARING vbelv.

SELECT vbeln

vgbel

ladgr

FROM lips

INTO TABLE t_lips2

FOR ALL ENTRIES IN t_delno1

WHERE vbeln = t_delno1-vbelv.

regards

girish