Skip to Content

Default sorting order in xsodata on HANA XS

Hi Experts,

I am using a UI5 app that uses xsodata to fetch data from HANA XS calculation views.

When analyzing the performance, I found that the queries being executed have a default ORDER BY clause, which lists all the properties from the SELECT clause. This happens even when we do not specify the sort order from the UI.

Running the same query without the ORDER BY clause improves the performance significantly.

Is there any way in which we can prevent the default ORDER BY clause from being added? Any configuration on HANA, a property on the xsodata file perhaps?

I did take a look at the syntax for xsodata here:

https://help.sap.com/viewer/b3d0daf2a98e49ada00bf31b7ca7a42e/2.0.02/en-US/73a801f25cbf425994f22b06d3850591.html

Couldn't find anything that helps.

Any help is much appreciated.

Thank you.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers