cardinality of the date is
low.
- Original Message -
From: "Peter" <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Sent: Tuesday, March 20, 2007 9:24:25 AM (GMT-0500) Auto-Detected
Subject: indexes and size
Hello,
I have a a large a table which a field called date, type date.
Hiep Nguyen wrote:
i believe "date" is a reserved word for mysql. don't use reserved word
for the column name. it's confused.
Using reserved words may be confusing, but it is fine as long as you put
them between backticks, as I'm sure the OP is aware of.
On Tue, 20 Mar 2007, Peter wrot
i believe "date" is a reserved word for mysql. don't use reserved word for
the column name. it's confused.
On Tue, 20 Mar 2007, Peter wrote:
Hello,
I have a a large a table which a field called date, type date.
When I select a smaller range e.g 3 months system uses the index 'date'.
That
Hello,
I have a a large a table which a field called date, type date.
When I select a smaller range e.g 3 months system uses the index 'date'.
That is for let's say 2 million rows.
If I select wider date range mysql stops using key. It says possible key
"date", but do not use it and goes over a
