Re: How MySQL Uses Indexes
Quote
The result:
id: 1
select_type: SIMPLE
table: t
type: range <--
possible_keys: a
key: a <--
key_len: 3 <--
ref: NULL
rows: 1267 <--
Extra: Using where
Where records above '2013-04-05' is important, mysql does not use index?
That says it did use the index. But (1269/8199 rows) was probably close to the cutoff for using the INDEX `a`.
Subject
Views
Written By
Posted
2231
May 04, 2013 08:28AM
Re: How MySQL Uses Indexes
830
May 07, 2013 07:47PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.