Robert, I can't remember which version you said you were on, but the
last few updates to the 5.0.x series have fixed some optimizer bugs.
You might check the functionality in the latest release (5.0.25).
See http://dev.mysql.com/doc/refman/5.0/en/news-5-0-x.html
for the list of 5.0 changes.
Of p
bject: Re: RE: Glitch in Query Optimizer
Have you tried using the USE/IGNORE/FORCE INDEX optimizer hints?
http://dev.mysql.com/doc/refman/5.0/en/join.html
Sometimes, MySQL's optimize just doesn't make the best choice.
Somewhat rare in my experience but it happens.
HTH,
Dan
On 10/3/06,
Have you tried using the USE/IGNORE/FORCE INDEX optimizer hints?
http://dev.mysql.com/doc/refman/5.0/en/join.html
Sometimes, MySQL's optimize just doesn't make the best choice.
Somewhat rare in my experience but it happens.
HTH,
Dan
On 10/3/06, Robert DiFalco <[EMAIL PROTECTED]> wrote:
Scratch
