Multi-variable indexes in postgres

Question

Im looking at an application where I will be doing quite a few SELECTs where I am trying to find column_a = x AND column_b = y. Is the correct to create that index that something like the following?

CREATE INDEX index_name ON table (column_a, column_b)

Milen A. Radev · Accepted Answer · 2010-05-09 20:15:08Z

2

Yes.

answered May 9, 2010 at 20:15

Milen A. Radev

63.1k22 gold badges111 silver badges112 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jackson Davis Over a year ago

Great, thanks. I searched the postgres documentation but didnt find anything like that.

Collectives™ on Stack Overflow

Multi-variable indexes in postgres

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related