Use of indexes
| От | Andre Schubert |
|---|---|
| Тема | Use of indexes |
| Дата | |
| Msg-id | 3CC8FD41.DDE7B82E@km3.de обсуждение исходный текст |
| Ответы |
Re: Use of indexes
|
| Список | pgsql-sql |
Hi all, i have a litte problem using indexes with datatypes int and int8. i have a table test:id1 int, id2 int8 if have to indexes: index_test_1: --------+---------id1 | integer btree index_test_2: --------+--------id2 | bigint btree If i do any explains i got the following: db_nmkm3=# explain select * from test where id1=1; Index Scan using index_test_1 on test (cost=0.00..3.01 rows=1 width=12) db_nmkm3=# explain select * from test where id2=1; Seq Scan on test (cost=0.00..20.55 rows=1 width=12) db_nmkm3=# explain select * from test where id2=1::int8; Index Scan using index_test_2 on test (cost=0.00..3.01 rows=1 width=12) Can somebody explain me whats wrong with me or my indexes? thanks in advance
В списке pgsql-sql по дате отправления: