RE: Primary Keys optional?

  • From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
  • To: <doodon@xxxxxxxxx>
  • Date: Tue, 22 Aug 2006 00:10:29 +0200

Hi Don


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

Mhmm... You don't need a PK to create indexes. Indexes store ROWIDs...
(only, partial exception, is an IOT) Or I misunderstood the essence of
your email?


HTH
Chris
--
//www.freelists.org/webpage/oracle-l


Other related posts: