Subject Indexes automatically used?
Author Clay Shannon
I've added several indexes to my database. Do these take effect
automatically when queries are run, or do I have to activate the indexes in
my Delphi code before calling the stored procs that query the db?

Also, I have one query that does this:

Order by sort_order, empno, shiftdate, created desc

Should I have four different indexes to speed up this query, or one
composite index?

Clay Shannon,

Dimension 4 Software

[Non-text portions of this message have been removed]