Multi-variable indexes in postgres
Im looking at 开发者_如何学Goan application where I will be doing quite a few SELECT
s 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)
Yes.
精彩评论