"Henry Combrinck" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
