Re: interesting snippet from Oracle FUD paper

ah, Given some of the statements about SQL server I should have had doubts
about the table :)

On Thu, Jan 20, 2011 at 1:38 PM, Go-Faster Consultancy Ltd. <
info@xxxxxxxxxxxxxxx> wrote:

>  There are no primary key indexes in PeopleSoft - they only unique
> indexes.
> Neither is there any database enforced RI.
>
>
> regards
> _________________________
> David Kurtz
> Go-Faster Consultancy Ltd.
> tel: +44 (0)7771 760660
> fax: +44 (0)7092 348865
> mailto:david.kurtz@xxxxxxxxxxxxxxx <david.kurtz@xxxxxxxxxxxxxxx>
> web: www.go-faster.co.uk
> Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com
> DBA Blogs: PeopleSoft: http://blog.psftdba.com, Oracle:
> http://blog.go-faster.co.uk
> PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba
>
>
>  ------------------------------
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Niall Litchfield
> *Sent:* Thursday, January 20, 2011 1:31 PM
> *To:* ORACLE-L
> *Subject:* interesting snippet from Oracle FUD paper
> *Importance:* High
>
> 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
>
>


-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

Other related posts: