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
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 indices -- one is a datetime