This website is not affiliated with, sponsored by, or approved by SAP AG.

Select with order by take much time and not execute

Development (ABAP Development WorkBench, ABAP/4 programming)

Moderators: Snowy, thx4allthefish, YuriT, Gothmog

Re: Select with order by take much time and not execute

Postby skarkada » Mon Dec 29, 2014 4:56 pm

You can't "fix" it. Depending on how many rows exist in the table BSIS, it could take a long time to first sort the data by ZUONR and then get first 10 rows. Just think about it. Finding any random 10 rows where ZUONR <> blank is much quicker than finding the top 10 ordered by ZUONR.
Sudhi Karkada
skarkada
 
Posts: 701
Joined: Mon Oct 21, 2002 1:12 pm
Location: Houston, TX, USA

Return to ABAP

Who is online

Users browsing this forum: No registered users and 4 guests





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.