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