Re: Foreign Key Columns And Indices

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: Foreign Key Columns And Indices
Дата
Msg-id Pine.BSF.4.21.0102042330470.35188-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на Foreign Key Columns And Indices  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Ответы Re: Foreign Key Columns And Indices  (Jan Wieck <janwieck@Yahoo.com>)
Список pgsql-hackers
On Mon, 5 Feb 2001, Christopher Kings-Lynne wrote:

> Just a quick question, when a column of a table is defined to be a foreign
> key, is it implicitly indexed, or does one still need to explicitly CREATE
> INDEX?

The foreign key columns are not currently implicitly indexed but you may
wish to index them if you're using a referential action other than no
action or restrict.




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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Like vs '=' bug with indexing
Следующее
От: Hannu Krosing
Дата:
Сообщение: Re: Like vs '=' bug with indexing