Indexes & Primary Keys (based on the same columns)

Поиск
Список
Период
Сортировка
От Ow Mun Heng
Тема Indexes & Primary Keys (based on the same columns)
Дата
Msg-id 1193024654.1104.26.camel@neuromancer.home.net
обсуждение исходный текст
Ответы Re: Indexes & Primary Keys (based on the same columns)  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: Indexes & Primary Keys (based on the same columns)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
I'm wondering if what I'm doing is redundant.

I have a primary key on columns (A,B,C,D)
and I've also defined an index based on the same columns (A,B,C,D)

and sometimes in the query explain, I see the pkey being used for the
scan instead of the index.

So.. That made me think perhaps the additional index on the _same_
parameter is redundant.

Appreciate comments.



В списке pgsql-general по дате отправления:

Предыдущее
От: Ow Mun Heng
Дата:
Сообщение: Re: command to view the tables
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Indexes & Primary Keys (based on the same columns)