How can I optimize an order by query speed over a large amount of results?
I asume an index does not help?