Skip to Content

ABAP Development : SAP HANA ORDER BY or SORT internal table

With a database on SAP HANA is the old performance rule still true that you should only use ORDER BY if the database is accessed by the same index for sorting as for reading; otherwise it is more efficient to import into internal table and then sort within the program ? (I am referring to a "rule" from the SAP ABAP Objects book by Keller and Kruger - page 734).

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 01, 2017 at 10:47 AM

    The recent performance hints are much shorter and don't say that you shouldn't sort at DB level. In the age of code push down that would be counter intuitive.

    https://help.sap.com/http.svc/rc/abapdocu_751_index_htm/7.51/en-US/index.htm?file=abenopen_sql_perfo.htm

    Add comment
    10|10000 characters needed characters exceeded