Re: Bizarre index creation - something wrong?

> > Why issue two commands in the first place - why not just
> > create the primary key on the two fields and not bother
> > with the unique index?

> Because if you do, Oracle will go through the burden of
> creating that unique index anyway, but unless you explicitly
> name the constraint and use USING INDEX clause, both
> index and constraint will receive system-generated names
> and index will be created with default storage attributes.
> Some people might prefer to use short cut, some might
> want more control on underlying index properties. I think
> it's a matter of personal preference.

Ah, OK, now I understand. They want to have a known named index rather than a system name monstrosity.

Does create constraint not work on 7? Anybody know where I can get docs on 7? TIA.

Paul...  

> Vladimir M. Zakharychev
Received on Wed Jun 07 2006 - 12:20:09 CDT