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
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 |