"Henry Combrinck" <henry(at)metroweb(dot)co(dot)za> writes:
> The above works fine - the index is used. However, extend the where
> clause with an extra line (say, col1 = 9) and the index is no longer used.
Do
explain analyze select ...
with both versions and send the results (preferably without line wrapping it).
I'm a bit skeptical about your description since I don't see how either query
could possibly be using an index here.
--
greg