"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).

Ivan