Composite indexes – Does column order matter?
When it comes to creating composite indexes, a common bit of advice we’re given is to put the most selective column first. And I’ve always just taken this at face value. But recently I got to thinking, is this still true? I’d never actually tested this theory myself. Does this rule still apply? So let’s […]
