SE16 Query Data Faster Than ABAP SQL

Development (ABAP Development WorkBench, ABAP/4 programming)

Moderators: Snowy, thx4allthefish, YuriT, Gothmog

Post Reply
dehinson
Posts: 143
Joined: Mon Oct 21, 2002 10:39 am
Location: Charleston, SC

SE16 Query Data Faster Than ABAP SQL

Post by dehinson » Mon Oct 21, 2002 10:43 am

I have been having trouble with ABAP SQL statements timing-out but find it strange that the same selects using SE16 query is quick. What gives? IS there someway to tie into whatever optimization SE16 is using?

Thanks for any assistance.
Dean.

TwoABAPers
Posts: 990
Joined: Sun Oct 20, 2002 9:16 pm
Location: web
Contact:

Post by TwoABAPers » Mon Oct 21, 2002 9:56 pm

Hello Dean.

There is an option in SE11/SE12/SE16 named Maximum no. of hits. which to a great extent contributes in making the selection end faster as compared to your SQL statements.

Try executing the same query in SE16 after removing the value from that field and see the results.

Regards
Sudhir/Mohit

Post Reply