Re: Primary Keys optional?

From: Don Doo <doodon_at_gmail.com>
Date: Mon, 21 Aug 2006 10:09:22 -0700
Message-ID: <36f8e4b00608211009w28f9ddbre92de01a5ee15bff@mail.gmail.com>

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_at_david-aldridge.com> 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
>
>
>

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

Received on Mon Aug 21 2006 - 12:09:22 CDT