Re: interesting snippet from Oracle FUD paper
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: info@xxxxxxxxxxxxxxx
- Date: Thu, 20 Jan 2011 13:41:59 +0000
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:
