"Sean P. Thomas" <[EMAIL PROTECTED]> writes:
> 1. Is there any performance difference for declaring a primary or
> foreign key a column or table contraint? From the documentation,
> which way is faster and/or scales better:
>
> CREATE TABLE distributors (
> did integer,
> name varchar(40),
> PRIMARY KEY(did)
> );
>
> CREATE TABLE distributors (
> did integer PRIMARY KEY,
> name varchar(40)
> );
These are equivalent -- the performance should be the same.
-Neil
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
