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