[GENERAL] Understanding how partial indexes work?

[Chris Velevitch]

I have a query on a table:-

     X between k1 and k2 or X < k1 and Y <> k3

where k1, k2, k3 are constants.

How would this query work, if I created an index on X and a partial
index on X where Y <> k3?


Chris
-- 
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
m: 0415 469 095
www.flashdev.org.au

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend