Unexpected query plan
От | Dave Cramer |
---|---|
Тема | Unexpected query plan |
Дата | |
Msg-id | 014201c0e2b4$543257f0$0401a8c0@INSPIRON обсуждение исходный текст |
Ответ на | how to convert Access to PG unless odbc driver(with sql file) (Ludovico Romano <romanolu@itc.it>) |
Ответы |
Re: Unexpected query plan
Re: Unexpected query plan |
Список | pgsql-general |
Hi All, Below is a simple table with an index on phonenumber, if I do a select on phonenumber without quotes then it does a sequence scan?? If I do put quotes, then it does use the index scan??? Anyone know what's going on? The version of postgres is 7.1 Regards, Dave test=# create table custbase (phonenumber int8, svctype char, svcchoice char, billtype char, ctype char); CREATE test=# create index custbaseidx on custbase (phonenumber); CREATE test=# \d custbase Table "custbase" Attribute | Type | Modifier -------------+--------------+---------- phonenumber | bigint | svctype | character(1) | svcchoice | character(1) | billtype | character(1) | ctype | character(1) | Index: custbaseidx test=# explain select * from custbase where phonenumber=5199400858; NOTICE: QUERY PLAN: Seq Scan on custbase (cost=0.00..25.00 rows=10 width=56) EXPLAIN test=# explain select * from custbase where phonenumber='5199400858'; NOTICE: QUERY PLAN: Index Scan using custbaseidx on custbase (cost=0.00..8.14 rows=10 width=56)
В списке pgsql-general по дате отправления: