DB Indexes Do Not Magically Compose

Sometimes you stumble on something that seems to be written to call you out personally somehow. This is one of those things. I have definitely been doing an awful lot of magical thinking when working with database indexes and this post is my intervention.