Unexpected query plan

From: "Dave Cramer" <Dave(at)micro-automation(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Unexpected query plan
Date: 2001-05-22 11:42:49
Message-ID: 014201c0e2b4$543257f0$0401a8c0@INSPIRON
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message snpe 2001-05-22 12:51:28 Multiple database - multiple query - multiple server
Previous Message Bruce Momjian 2001-05-22 11:31:18 Re: Re: [GENERAL] Queries across multiple databases ?(was: SELECT from a table in another database).