I am having to write my own query plans for many of my queries and stored
procedures, as I am finding that the optimizer generally chooses the wrong
indices.

Any hints on this?

Also, when and under what circumstances can an index NOT be used in a query
plan?


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