FOREIGN KEY AND INDEXEX
От
JORGE MALDONADO
Тема
FOREIGN KEY AND INDEXEX
Дата
Msg-id
f03943a00810281304r3e6340a8qa1669047d87d1640@mail.gmail.com
Список
Дерево обсуждения
FOREIGN KEY AND INDEXEX "JORGE MALDONADO" <jorgemal1960@gmail.com>
Re: FOREIGN KEY AND INDEXEX Alan Hodgson <ahodgson@simkin.ca>
I need to define an index for a table but such an index already exists as a foreign key.
I have fk_state (a foreign key) and I need a common index (ix_state).
Should I define the index or does the foreign key work like an index too?
With respect,
Jorge Maldonado
В списке pgsql-novice по дате отправления