Provide alternative select statements to improve performance
I want to improve the performance of my report. below statement is taking more time. Please provide any suggestions to include alternative statement for the below select statement.
SELECT H~CLMNO H~PNGUID P~PVGUID V~PNGUID AS V_PNGUID V~AKTIV V~KNUMV P~POSNR V~KATEG AS ALTNUM V~VERSN APPENDING CORRESPONDING FIELDS OF TABLE EX_WTYKEY_T FROM ( ( PNWTYH AS H INNER JOIN PNWTYV AS V ON V~HEADER_GUID = H~PNGUID ) INNER JOIN PVWTY AS P ON P~VERSION_GUID = V~PNGUID ) FOR ALL ENTRIES IN lt_claim WHERE H~PNGUID = lt_claim-pnguid AND V~AKTIV IN rt_AKTIV AND V~KATEG IN IM_ALTNUM_T.
Moderator message - Moved to the correct forum
Edited by: Rob Burbank on May 14, 2009 11:00 AM