only exists in 4.0.16. Until you can use
another version, I guess you'll have to use USE INDEX. :-/
Hope that helps.
Matt
- Original Message -
From: "Rob Brackett"
Sent: Tuesday, November 18, 2003 4:33 PM
Subject: Optimizer Troubles
> I've got a table with two
I've got a table with two indices -- one is a datetime with massive
cardinality, and another is a varchar with only 9 distinct values. The
optimizer seems to choose the varchar over the datetime in all cases
unless I specifically say USE INDEX(). Is there some way to make MySQL
"smarter" in this
