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 Con
[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: