Databasesmedium

Composite index order: why does column order matter?

Answer

Most databases use the left‑most prefix of a composite index. That means an index on (A, B, C) can speed up queries on A or A,B, but not on B alone. Choose the order based on common filters and selectivity.

Related questions

Databases

Autocommit vs explicit transactions: when does it matter?

#database#transactions#autocommit

Databases

OLTP vs OLAP: what’s the difference?

#database#oltp#olap

Databases

Denormalization: when might you do it and what’s the trade‑off?

#database#denormalization#performance

Databases

Partitioning vs sharding: what’s the difference?

#database#partitioning#sharding

Databases

Isolation levels: what’s the difference between Read Committed, Repeatable Read, and Serializable?

#database#transactions#isolation

Databases

Deadlock: what is it and how do databases resolve it?

#database#transactions#locks