Re: Unique and non unique index

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 15 Mar 2006 08:54:37 -0800
Message-ID: <1142441677.740999.247370@i39g2000cwa.googlegroups.com>

Mark is correct. Oracle started supporting the use on non-unique indexes to support PK and UK constraints with version 8.0. Optional syntax for the constraint clauses provide the DBA with the means to take control of the type, naming, location, and storage parameters for the indexes used to enforce constraints. It is advisable to use this feature rather than just accept the database defaults.

IMHO -- Mark D Powell -- Received on Wed Mar 15 2006 - 10:54:37 CST