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
