Re: [PERFORM] Index type

Ilia, If I create btree index on all columns (A,B,C..), here is what explain analyze gives me: - Index Scan using all_ind on test2 (cost=0.00..4.51 rows=1 width=24) (actual ti me=0.000..0.000 rows=5 loops=1) Index Cond:

[PERFORM] Index type

Hello, I have a request like SELECT ... WHERE x=A=y AND t=B=u AND z=C=w AND .. 5 columns are in BETWEEN clauses. What is the best index I could use? If I create btree index on all columns (A,B,C..), here is what explain analyze gives me: