> I'm sick and tired of manually figuring out three-page-long Peoplesoft SQL with umpteen levels of views on views > and impenetrable execution plans. On a good day. > That is precisely where an automatic tool like the tuning pack becomes invaluable. It saves heaps of time. While I sympathise with the rest of the sentiment, I have yet to agree with the suggestions of the tuning pack when applied to PeopleSoft nested views. 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 DBA Blogs: PeopleSoft: http://blog.psftdba.com, Oracle: http://blog.go-faster.co.uk PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba -- //www.freelists.org/webpage/oracle-l