Forum OpenACS Q&A: Response to How does postgresql handle indexes on multiple columns?

Collapse
4: Response to How does postgresql handle indexes on multiple columns? (response to 1)
Posted by Jonathan Ellis on 01/23/02 04:43 PM
For the record, I was wrong and Sybase is the same way -- you have to include the leading index column in your query for the db to make use of it.  (Except for covered nonmatching index scans but that's not what I was talking about.)