"Paulie" <plinehan_at_yahoo.com> wrote in message
news:1149676667.760683.25360_at_j55g2000cwa.googlegroups.com...
>
> 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.
--
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com
Received on Wed Jun 07 2006 - 06:25:24 CDT
