"Group by" and "index".
| От | Vlad Marchenko |
|---|---|
| Тема | "Group by" and "index". |
| Дата | |
| Msg-id | 008801bf6b68$4b212f20$2d7a01d4@kuzja обсуждение исходный текст |
| Ответы |
Re: [SQL] "Group by" and "index".
|
| Список | pgsql-sql |
Hi, PostgreSQL 6.5.3. I've created the following index: >create index test_index on test (filed1); >vacuum; And then: >explain select field1 from test group by field1; NOTICE: QUERY PLAN: Group (cost=2510.40 rows=58709 width=12) -> Sort (cost=2510.40 rows=58709 width=12) -> Seq Scan on test (cost=2510.40rows=58709 width=12) It don't use this index :-(. I've tried to create two types of index: b-tree and hash - both doesn't work until "group" is present. If I type > explain select field1 from test where field1='tra-ta-ta'; NOTICE: QUERY PLAN: Index Scan using test_index on test (cost=2.05 rows=2 width=12) It work this way. Any ideas? _____________ Vlad Marchenko
В списке pgsql-sql по дате отправления: