Creating useful MySQL indexes – InnoDB & MyISAM using B-Tree

Any database developer understands that indexing is extremely important for optimal query performance. Here we’ll attempt to get beyond adding one column per index to being more purposeful about intelligent index creation. In order to be able to efficiently index…