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]