A composite index covers several columns, in a specific order. It mainly serves queries that filter on the first columns of the index (leftmost prefix rule), and column order matters: equalities first, then the range or sort column. A single index can replace several simple indexes.
Example
CREATE INDEX ON commandes (client_id, date);