Join Table
От
T E Schmitz
Тема
Join Table
Дата
Msg-id
41866598.5040909@numerixtechnology.de
Список
Дерево обсуждения
Join Table T E Schmitz <mailreg@numerixtechnology.de>
Re: Join Table Tom Lane <tgl@sss.pgh.pa.us>
Re: Join Table Michael Fuhr <mike@fuhr.org>
Re: Join Table T E Schmitz <mailreg@numerixtechnology.de>
Re: Join Table Michael Fuhr <mike@fuhr.org>
Re: Join Table Mischa Sandberg <ischamay.andbergsay@activestateway.com>
Re: Join Table Richard Huxton <dev@archonet.com>
Hello, I have created the following join table: the two FKs are the PK of the table. Typically, I will need to select rows for a given ITEM_FK. Question: is it necessary/advisable to create an index for the ITEM_FK column? Or is this redundantbecause this column is already one of the PK columns? CREATE TABLE SUPPLY ( ITEM_FK integer NOT NULL, CONTACT_FK integer NOT NULL, COST numeric (7,2), PRIMARY KEY (ITEM_FK,CONTACT_FK) ); -- Regards/Gruß, Tarlika Elisabeth Schmitz
В списке pgsql-sql по дате отправления
