Composite Indexes in PostgreSQL & MySQL: Column Order Guide

Adding three separate single-column indexes on tenant_id, status, and created_at will not make a multi-filter dashboard query fast—in fact, putting columns in the wrong order inside a composite B-Tree