View Single Post

   
  #1 (permalink)  
Old 02-27-2008, 05:18 AM
aj
 
Posts: n/a
Default Difference between unique constraint and unique index?

DB2 WSE 8.1 FP5
Red Hat AS 2.1

What is the difference between adding a unique constraint like:

ALTER TABLE <SCHEMA>.<TABLE> ADD CONSTRAINT CC1131378283225 UNIQUE (
<COL1>) ;

and adding a unique index like:

CREATE UNIQUE INDEX <SCHEMA>.<BLAH> ON <SCHEMA>.<TABLE> (<COL1> ASC)
PCTFREE 10 MINPCTUSED 10;

Just curious.

TIA

aj
Reply With Quote