You need do SHOW INDEXES FROM ;
You will see a column called Cardinlaity (another word for a unique count).
This tells you how many distinct values exists at the given Seq_in_index for
the index.
If the Cardinality of an index is low in relation to the number of rows in the
table,
then MySQL m
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
