> > 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 _______________________________________________ New York PHP Users Group Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk http://www.nyphp.org/Show-Participation
