Foreign keys
От | Dean Gibson (DB Administrator) |
---|---|
Тема | Foreign keys |
Дата | |
Msg-id | 52B1E31C.8010000@ultimeth.com обсуждение исходный текст |
Ответы |
Re: Foreign keys
Re: Foreign keys |
Список | pgsql-general |
I have general question about FOREIGN KEYs:
- Suppose I have table A with primary key X, and another table B with field Y.
- When I 'ALTER TABLE "B" ADD FOREIGN KEY( "Y" ) REFERENCES "A" ON UPDATE CASCADE ON DELETE CASCADE', that clearly spends some time building a separate index. Since there is already a unique index on X, presumably (?) the index being built is on Y.
- However, the PostgreSQL documentation seems to indicate that it's a good idea to also separately create an index on Y.
- Why, and why is the FOREIGN KEY index different from the ones on X and Y in any way but trivial?
- If I need the separate index on Y, should it be built before or after the FOREIGN KEY constraint?
-- Mail to my list address MUST be sent via the mailing list. All other mail to my list address will bounce.
В списке pgsql-general по дате отправления: