Subject Re: [firebird-support] Indexes automatically used?
Author Aage Johansen
Clay Shannon wrote:
> Is the db "smart enough" to automatically use the composite index in the
> case mentioned:
> Order by sort_order, empno, shiftdate, created desc

If the engine is "smart enough" it may choose not to use the index.
Very often, sorting the result set is faster than following the index.

Aage J.