The Optimization That (Often) Isn’t: Index Merge Intersection

(Ernie Souhrada) Prior to version 5.0, MySQL could only use one index per table in a given query without any exceptions; folks that didn’t understand this limitation would often have tables with lots of single-column indexes on columns which commonly appeared in their WHERE clauses, and they’d wonde

Read More - Register for Free Membership