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.