NYCPHP Meetup

[nycphp-talk] Adding indexes

Hans Zaunere lists at zaunere.com
Tue Mar 23 11:45:37 EDT 2010


> > One caveat to this is that mysql will only use one index per table in
> > your query.
> 
> I've never heard that before.  Do you have a citation from the manual on
> MySQL's website, please?

It's thrown around through some of the links Rob mentioned, but it's true
and notorious issue with indexing in MySQL.  Furthermore, indexes must be in
left-right ordering, if there's a multi-column index.  Things I suppose are
trying to improve a bit, but the rule is typically to create specific
indexes for every major type of query.

H





More information about the talk mailing list