Skip to Content
0
Former Member
May 31, 2011 at 09:26 AM

Secondary Index exists still full table scan

111 Views

Hi Friends,

Analyzed trace and found out that Report SDLIEFSPE is having performance issues in following select

SELECT * FROM VBUK INTO CORRESPONDING FIELDS OF TABLE LVBUK

WHERE SPSTG IN ('B','C')

AND LFGSK IN ('A','B')

AND ( ( LSSTK IN ('B','C') )

OR CMGST EQ 'B' ).

created a secondary index on Table VBUK on following fields

MANDT

LFGSK

CMGST

LSSTK

SPSTG

When checked the SQL statement in ST05 on Development system the execution time has reduced considerably and index is in use. Same behaviour on Quality system.

Got transportied to Production server and checked that still full table scan and index not in use.

What could be the reason & why different behaviour on two systems.

Thanks

For program