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
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
Hello
Searched around, but could not find this mentioned.
I've noticed the following behaviour in 7.4.5:
[explain analyse] select * from foo where
col1 = 1 or
col1 = 2 or
col1 = 3 or
col1 = 4 or
col1 = 5 or
col1 = 6 or
col1 = 7 or
col1 = 8;
where an index on foo.col1 exists.
The above works
On Wed, 20 Oct 2004, Henry Combrinck wrote:
Hello
Searched around, but could not find this mentioned.
I've noticed the following behaviour in 7.4.5:
[explain analyse] select * from foo where
col1 = 1 or
col1 = 2 or
col1 = 3 or
col1 = 4 or
col1 = 5 or
col1 = 6 or
col1 = 7 or
col1 =