cancel
Showing results for 
Search instead for 
Did you mean: 

Default sorting order in xsodata on HANA XS

joel_john1
Explorer

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/73a801f25cbf425994f22b06d3...

Couldn't find anything that helps.

Any help is much appreciated.

Thank you.

Accepted Solutions (0)

Answers (0)