Re: To index or not to index ? that is the (constraint) question.

> Now, back to the master table and the real question I'm asking. Given > that I've got a unique constraint on the primary key column on the > master table, is it necessary to also create a unique index on that > column, or is that implicit in the constraint? A PRIMARY KEY implies a UNIQUE CONSTRAINT implies a UNIQUE INDEX. (And NOT NULL). So you only have to specify the PRIMARY KEY. HTH. -- Ciao, Billy +------------------------------------------------------------------------------+ | Billy Wheeler Junior Programmer / Director The West Solutions Group | +------------------------------------------------------------------------------+ | Oracle isn't the answer. Oracle is the question, and the answer is "no". | +------------------------------------------------------------------------------+