Considering Index Design When Using A Nullable DateTime Column To Record A Scheduled Action

Ben Nadel explores the composition of a composite index in MySQL when using a nullable DateTime column to track scheduled actions. This is particularly interesting because it forces you arrange the columns in the opposite order of what would be the normal "mental model" for record identification. SQL is fun!