n00b
Reputation: 349
Indexing columns included in a joint primary key
Given a DB with a primary index on the columns foo and bar, is it worthwhile adding an individual index on the single column foo (assuming that most queries are ... WHERE foo = '...')? If it makes a difference, I'm on pgsql.
Upvotes: 1
Views: 111
Answers (1)
Grisha Weintraub
Reputation: 7996
If index is (foo,bar) - in this order, you don't need another index on foo.
Otherwise you do.
Upvotes: 2
Related Questions
- Postgres and indexes on foreign keys and primary keys
- postgres indexing all columns of composite primary key
- Indexing in Postgres with common columns
- PostgreSQL: Create an index for fields within a composite type?
- PostgreSQL composite primary key
- Do i need index for composite primary key where each column is foreign key
- Indexing columns across multiple tables in PostgreSQL
- Indexing all columns which are foreign key to a table
- How to properly use index on multiple columns
- Postgresql and primary key, foreign key indexing