RE: interesting snippet from Oracle FUD paper

From: Go-Faster Consultancy Ltd. <>
Date: Thu, 20 Jan 2011 13:54:14 -0000
Message-ID: <FFAF200E56BB48CF9725C4BFB7413753_at_GOFASTER4>

With PeopleSoft the numbers vary with product and version, but they are reasonable to within an order of magnitude (neglecting multiple copies of working storage tables)..
I interpreted PK to mean that database constraint Yes, unique indexes do enforce uniqueness, but there are some nullable key columns!    


David Kurtz
Go-Faster Consultancy Ltd.
tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
Book: PeopleSoft for the Oracle DBA:

DBA Blogs: PeopleSoft: <> , Oracle: <> PeopleSoft DBA Forum:  

From: [] On Behalf Of Toon Koppelaars
Sent: Thursday, January 20, 2011 1:42 PM To:
Subject: Re: interesting snippet from Oracle FUD paper Importance: High

How is that number determined?

You can have PK enforcement using non-unique indexes...

On Thu, Jan 20, 2011 at 2:31 PM, Niall Litchfield
<> wrote:

There is an Oracle whitepaper comparing RAC (wonderful, performant and simple) with SQL Server 2008 (awful, slow and complex :)) In it there is an interesting table for ERP schemas. Now I know some of apps predates declarative referential integrity, but that was introduced an awfully long time ago now.

                        Tables   Primary Key Indexes     
Peoplesoft               7,493                 6,438     
Oracle eBusiness (ERP)   8,155                   800  
SAP                     16,500                16,329 

Niall Litchfield
Oracle DBA

Toon Koppelaars
RuleGen BV

(co)Author: "Applied Mathematics for Database Professionals"

Received on Thu Jan 20 2011 - 07:54:14 CST

Original text of this message