Using index

From: Ice Planet <ice(at)adiemus(dot)sk>
To: pgsql-general(at)postgresql(dot)org
Subject: Using index
Date: 2000-06-07 10:47:33
Message-ID: SAK.2000.06.07.hghtsskp@adiemus
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello

I have one problem with indexes. I have serched the mailing lists and found there a lot of info about indexes, but not the answer.

I done following:

create table t1 (a1 int8 not null , a2 int8 not null, a3 char (128), primary key (a1,a2));
OK
create index i1 on t1 (a1);
OK

Then i inserted about 5000 rows into into this table

Then i use EXPLAIN SELECT a1 FROM t1 WHERE a1 = 444
and the explain told me sequential scan...

I don't know where is the problem. I think that the optimizer should use index ???
(I done vacuum and nothing changed)

Thanks for help

Best regards
Ice Planet

e-mail: ice(at)adiemus(dot)sk
ICQ#: 67765483

Browse pgsql-general by date

  From Date Subject
Next Message Matt Goodall 2000-06-07 11:05:27 Column types via ODBC interface
Previous Message Vince Vielhaber 2000-06-07 10:43:48 Re: Releases: 7.0.1, 7.0.2