Re: Primary Keys

In article: <pconnors.797748419_at_BIX.com> pconnors_at_BIX.com (pconnors on BIX) writes:
>
> DPWCC02.OBERLE02_at_SSW.ALCOA.COM (Oberle, John F.) writes:
>
> >Can someone tell me the significance of the primary key
> >constraint. What are the advantages or disadvantages over
> >creating unique indexes.
 

> >Thanks in advance;
 

> >John F. Oberle
>
>
> They are pretty much the same under the hood.
>
> The primary key constraint creates a unique index, but it
> uses a system-generated name and defaults the storage and
> tablespace. For that reason, our shop is putting a standard
> in place that constraints are to have the index name
> and storage info created explicitly.
>
>
>

-- 

	Your shop should consider using the 'using index' clause to specify
the tablespace and the storage info.
---
	Tim London			phone :	+44 1753 662393
	Oracle DBA,Trainer and		mobile:	+44 836 287064
	part time OU tutor		Email : tim_at_artemis.demon.co.uk