Subject Re: [firebird-support] Indexes automatically used?
Author Ivan Prenosil
"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

ORDER BY can use only one index.
If you have separate indexes for each field, only one can be used (for sort_order field).