David Griffiths wrote:
Really? I had no idea. I am pretty sure that only Day will have a range.
Our index is currently, (yearmonth, day, stem_base), so I need to drop
and recreate it.
I think part of the slowness is the size of the table as well. We have
data going back years in there. I am
Mysql uses multiple-column indexes from left to right. Multiple-column
indexes are most effective when the column with a range criteria comes as
far to the right as possible. Think of the index as sorting your data into
a book where the first column is the chapter, the second column is the
Really? I had no idea. I am pretty sure that only Day will have a range.
Our index is currently, (yearmonth, day, stem_base), so I need to drop
and recreate it.
I think part of the slowness is the size of the table as well. We have
data going back years in there. I am thinking about breaking
Have you tried using between instead of = =? We have found that between
in some cases works better than . Not saying it will make it use the
correct index.
Donny
-Original Message-
From: David Griffiths [mailto:[EMAIL PROTECTED]
Sent: Friday, July 30, 2004 9:35 PM
To: MySQL List