backenddatabasessql
Column order matters in a composite index
Anonymous
A composite index on account_id and created_at is most useful when a query constrains account_id and then filters or orders by created_at. An index starting with created_at is a different structure, not an interchangeable one. Check the query plan and write overhead before adding either.
0