Re: Primary Keys optional?

David,

 Large fact tables will be generally partitioned.  Can we create local
indexes on a partitioned table that has no primary key?.

Don


On 21 Aug 2006 09:00:53 -0700, David Aldridge <david@xxxxxxxxxxxxxxxxxx>
wrote:


It's quite conventional to not have a PK on a large fact table, but FK's
ought to be present even if they are set to DISABLE/RELY.


--
http://www.freelists.org/webpage/oracle-l

References:

Re: Primary Keys optional?
From: Niall Litchfield

RE: Primary Keys optional?
From: Jesse, Rich

Re: Primary Keys optional?
From: Dhimant Patel

Re: Primary Keys optional?
From: David Aldridge

Other related posts: