A rule of thumb for choosing column order in indexes

(Baron Schwartz) I wanted to share a little rule of thumb I sometimes use to decide which columns should come first in an index. This is not specific to MySQL, it’s generally applicable to any database server with b-tree indexes. And there are a bunch of subtleties, but I will also ignore those for

Read More - Register for Free Membership