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.
uses <b>clustered index</b> to return the resultset efficiently and speedily
SELECT statement is not necessarily optimized by the database system or executed with the correct index. This can result in increased runtime costs. You should only use ORDER BY if the database sort uses the same index with which the table is read. To find out which index the system uses, <b>use SQL Trace in the ABAP Workbench Performance Trace.</b> If the indexes are not the same, it is more efficient to read the data into an internal table or extract and sort it in the ABAP program using the SORT statement.
uses <b>clustered index</b> to return the resultset efficiently and speedily
SELECT statement is not necessarily optimized by the database system or executed with the correct index. This can result in increased runtime costs. You should only use ORDER BY if the database sort uses the same index with which the table is read. To find out which index the system uses, <b>use SQL Trace in the ABAP Workbench Performance Trace.</b> If the indexes are not the same, it is more efficient to read the data into an internal table or extract and sort it in the ABAP program using the SORT statement.
To sort the selection set in ascending order by the primary key, use the following:
SELECT <lines> *
...
... ORDER BY PRIMARY KEY.
This sorting method is only possible if you use an asterisk (*) in the SELECT clause to select all columns. Furthermore, it only works if you specify a single database table in the FROM clause. You cannot use views or joins, since neither has a defined primary key.
Bluesky
