On Fri, Sep 26, 2003 at 08:35:54 -0400, Jodi Kanter <[EMAIL PROTECTED]> wrote: > Is there any argument to support using table constraints over column > constraints in a situation where there are no PKs or FK references that > are composed of more than one column?
Functionally they should be the same, so I think it is more of a style issue. > Is the automatic PK index generated on for table constraints or for either? > Jodi Foreign key references do not create indexes. There already needs to be an existing unique index (primary key will generate a unique index) on the table being referenced or the constraint creation will fail. Optionally you may also want to create an index on the referencing columns if you will be doing lots of deletes (and I think updates before 7.4) on the referenced table. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
