An index is a database object that improves the speed of data retrieval operations on a table. It is created on one or more columns of a table and stores a subset of data in a sorted order, allowing faster searches, lookups, and joins. Common index types in PostgreSQL include B-tree, Hash, GiST, GIN, and SP-GiST. ![[ex_index_only_scan.svg|300x300]]