Bruno Wolff III [mailto:[EMAIL PROTECTED] Wrote:
> You only want to use partial indexes when they don't cover > the whole table. They make sense to enforce uniqueness of a > column under some condition and when you can save significant > space (becuase the condition is only satisfied for a small > fraction of rows). Yes, I know that,. I misunderstood the original post as a request for queries NOT to use indexes where it doesn't match the table contents. .. John ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
