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 < niall.litchfield@xxxxxxxxx> 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 > http://www.orawin.info > -- Toon Koppelaars RuleGen BV Toon.Koppelaars@xxxxxxxxxxx www.RuleGen.com TheHelsinkiDeclaration.blogspot.com (co)Author: "Applied Mathematics for Database Professionals" www.rulegen.com/am4dp-backcover-text