Thanks, David! You beat me to the punch. In our PS Financials database the application ID has 44,138 tables and 52,040 indexes. In our PS Student Admin/HR database, the application ID has 29,411 tables and 36,854 indexes. We would be happy to have an app that had so few tables/indexes. Have a good one folks! Carol On Thu, Jan 20, 2011 at 8:38 AM, 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 > >