On Sun, May 1, 2005, Geo Carncross <[EMAIL PROTECTED]> said: [snip] > It just hits me now, that your new plan shows the use of the physmessage > index on the index Cond- however, our old plans did not. That meant we > were walking the entire index, so I'm _guessing here_, but it's probable > that your index was just too sparse. I probably would've had more > problems as time went on (disk blocks moving, precache by os, etc).
Does PostgreSQL allow hints in the SQL? In MySQL, you can force a join to use certain indexes with USE INDEX: http://dev.mysql.com/doc/mysql/en/join.html Oracle allows something similar: http://www.databasejournal.com/features/oracle/article.php/2213391 The syntax is all over the place, so we'd have to think more about the modularization of certain queries into database specific versions, but that's already something we're talking about, no surprises there. Aaron
