Scott Cain <[EMAIL PROTECTED]> writes: > So, the question is, is there a way I can force the query planner to use > the index I want it to use?
No (and I don't think there should be). Given that it *can* generate
the plan you want, this is clearly an estimation failure. What is the
index it does use? Would you show us EXPLAIN ANALYZE results when
using each index?
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
