Subject Re: SELECT Order by DESC
Author Aage Johansen
Szakály Balázs wrote:
> Why cannot use FB any index on select with desc order?
> Select * from TTT order by FFF desc
> There is an index to fff but not desc order. Why cannot use in this
> case?=20
> So, i need to create 2 indexes to all table, where i need desc order
> with high response time.

Indexes are often NOT very helpful for the ORDER BY clause. I find that
most of the time I get better results when I can prevent IB/Fb from using
an index (for the ORDER BY).

Aage J.