[nycphp-talk] Adding indexes
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.
More information about the talk