A composite index indexes multiple columns together (e.g., (org_id, email)). It helps when queries filter/sort by the leftmost prefix of those columns, reducing scans and speeding up lookups.