Hi , want to check if sorted index is recommended for order by on a field to reduce lateny ? If yes , want to see how thats working ?

Most indexing helps with filtering. Sorted index may indirectly help with other parts of query mostly due to locality.

Yes, it will help on filter query. But you can only have one column sorted

Thanks @Mayank @Xiang Fu

Is there any other recommendations to improve performance of ordering results?

What’s the query?