I have a table
highscore containing the columns:
- more irrelevant ones...
The query most often run on it is:
SELECT * FROM highscore WHERE game = :gamename AND date BETWEEN :start AND :end ORDER BY score DESC LIMIT 10
I currently have three B-tree indexes on this table, one for each column above.
I'm thinking that I could further optimize performance by adding some sort of multi-column index, which starts with
game. However, when thinking through the various options for the next column(s), I get stuck.
Can I use a multi-column index for further optimization here?
I'm using PostgreSQL 9.1