Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

need help in performance

Former Member

‎2007 Dec 10 10:18 AM

0 Likes
226

hallow

i doing this select and it take more then 10 minutes and i don't now way because

object_key have just 60 entries ?

how i can slve this problem?

Regards


  SELECT * FROM covp APPENDING TABLE *covp
          FOR ALL ENTRIES IN object_key
           WHERE kokrs EQ '1000'
           AND   objnr EQ object_key-objnr
           AND   budat IN so_budat
           AND   stflg EQ space .

1 REPLY 1
Read only

Former Member

‎2007 Dec 10 10:28 AM

0 Likes
206

Insted of this try this.

SELECT * FROM covp

INTO TABLE temp_covp

FOR ALL ENTRIES IN object_key

WHERE kokrs EQ '1000'

AND objnr EQ object_key-objnr

AND budat IN so_budat

AND stflg EQ space .

loop at temp_covp.

append temp_covp to covp.

endloop.

So that we can reduce the burdan on Select query.

All the best to you.

- Mohan