The B-tree index is PostgreSQL's default index type. It keeps values sorted in a balanced tree, and serves equalities, ranges (<, >, BETWEEN), sorts and LIKE prefixes (depending on collation settings). Each index speeds up reads but slows down writes and takes up space.
Example
CREATE INDEX idx_commandes_date ON commandes (date);