RE: interesting snippet from Oracle FUD paper
- From: "Go-Faster Consultancy Ltd." <info@xxxxxxxxxxxxxxx>
- To: <niall.litchfield@xxxxxxxxx>, "'ORACLE-L'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 20 Jan 2011 13:38:58 -0000
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
web: www.go-faster.co.uk
Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com
<http://www.psftdba.com/>
DBA Blogs: PeopleSoft: http://blog.psftdba.com <http://blog.psftdba.com/> ,
Oracle: http://blog.go-faster.co.uk <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
Other related posts:
