Not scanning by index
От | Magnus Naeslund\(f\) |
---|---|
Тема | Not scanning by index |
Дата | |
Msg-id | 010301c0d405$7329fb30$020a0a0a@totalmef обсуждение исходный текст |
Ответы |
Re: Not scanning by index
|
Список | pgsql-hackers |
I have a table: create table forsamling ( id SERIAL, for_id int4 unique not null, kund_flag int8 not null default 1, online smallint default 0, klar smallint default 0, ); create index forsamling_idx on forsamling(for_id,online,klar,kund_flag); It has about 1000 entries in this table... Why doesn't it go by indexes when i search the smallints and int8s, but it works with the integer SERIAL (SERIAL creates it's own index)? What can i do to make it go by index? /Magnus explain select * from forsamling where klar = 1; NOTICE: QUERY PLAN: Seq Scan on forsamling (cost=0.00..23.50 rows=1 width=88) ----- explain select * from forsamling where kund_flag = 123; NOTICE: QUERY PLAN: Seq Scan on forsamling (cost=0.00..23.50 rows=1 width=88) ----- explain select * from forsamling where for_id = 123; NOTICE: QUERY PLAN: Index Scan using forsamling_idx on forsamling (cost=0.00..2.01 rows=1 width=88) -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-Programmer/Networker [|] Magnus NaeslundPGP Key: http://www.genline.nu/mag_pgp.txt -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
В списке pgsql-hackers по дате отправления: