Re: Foreign keys and indexes

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Foreign keys and indexes
Дата
Msg-id 46657CD2.6040101@g2switchworks.com
обсуждение исходный текст
Ответ на Re: Foreign keys and indexes  (Marc Compte <mcompte@sigte.udg.es>)
Список pgsql-general
Marc Compte wrote:
> Thanks to everyone for the prompt reply :)
>
> Good thing about answers is when they raise up new questiosn, so you
> can keep on learning all the time.
>
> This one answer, for instance, brings me another question. Does having
> a composite primary mean the system will create an individual index on
> each of the fields? or is the index created on the composition only?
>
> For instance, in the implementation of a N:M relationship, declaring
> the primary as (foreign1, foreign2) will create two indexes? or just one?

Just one (and please don't top post.  :) )

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

Предыдущее
От: "Marko Kreen"
Дата:
Сообщение: Re: Encrypted column
Следующее
От: Oliver Elphick
Дата:
Сообщение: Re: Foreign keys and indexes