Can someone tell me if there is a performance difference in specifying primary key constraints at the table level versus the column level. For example, CREATE TABLE ... ( COLUMN1 ... CONSTRAINT TAB_PK PRIMARY KEY, COLUMN2 ..., COLUMN3 ...); versus defining the constraint at table level: CREATE TABLE .... (CONSTRAINT TAB_PK PRIMARY KEY ( COLUMN 1), COLUMN1 ....., COLUMN2 ....., COLUMN3 .....); -- M. Beatriz Roque Received on Mon Nov 21 1994 - 15:38:44 CET
( COLUMN1 ... CONSTRAINT TAB_PK PRIMARY KEY, COLUMN2 ..., COLUMN3 ...); versus defining the constraint at table level: CREATE TABLE .... (CONSTRAINT TAB_PK PRIMARY KEY ( COLUMN 1), COLUMN1 ....., COLUMN2 ....., COLUMN3 .....);
-- M. Beatriz Roque
Original text of this message
