In general, you should structure your where clauses to use the indexes. Then you should structure them so that the greatest amount of screening is done first.

Best of all, you should use EXPLAIN PLAN and determine the optimal structuring that way.

Good luck.