Re: interesting snippet from Oracle FUD paper

  • From: Toon Koppelaars <toon.koppelaars@xxxxxxxxxxx>
  • To: niall.litchfield@xxxxxxxxx
  • Date: Thu, 20 Jan 2011 14:41:53 +0100

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

Other related posts: