Wells Oliver <wells.oliver@xxxxxxxxx> writes: > Is it really always true that querying off any column that's not the first > column of a multi-column index will NOT use that index? Nope. The planner will consider that, though in most cases it's likely to estimate that there's no benefit to using the index in such cases. Try reading the *actual* docs, not some third-party site: https://www.postgresql.org/docs/current/indexes-multicolumn.html regards, tom lane
