NYCPHP Meetup

[Hans Zaunere]

> > 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