My grid displays the content of a Remote View with 1.000.000+ records from SQL server. I use data fetching to speed up the application. The user can click on the column's headers to change the order of the grid.

If I use indexes to quickly change the order, then the whole table is downloaded. This is very slow. So probably I have to make new query every time the user changes to order. The problem is that the SELECT expression is read-only at runtime in the Remote View. I can't use "?parameters" at ORDER BY as with FILTER in the View Designer. I can't use "CREATE VIEW" to overwrite the existing Remote View because more users are using the same application with the same .DBC.

Any ideas? Thanks in advance!