Skip to Content
0
Aug 20, 2015 at 05:27 AM

Query Performance issue

22 Views

Hi all,

i have one issue that i am going to share with you please help me to resolve it :

I have one situation in whch i am using one statement in report are as below :

SELECT * FROM vekp INTO TABLE lt_vekp_seq

WHERE exidv LIKE lv_new_exidv

ORDER BY exidv DESCENDING.

FYI, in lv_new_exidv the value which is getting passed that is 'V0MM001S%'.

but its performance is very slow.

can u please let me know if there is any other statement that i can use instead of this statement.

Thanks in advance.