> View this now

Published on: May 04, 2009
Type of content: WHITE PAPER
Format: Unknown
Price: FREE

Overview:
PeopleSoft business applications are the leader in e-business productivity and efficiency enhancements in databases. Their solutions automate business processes such as Human resources, finance, supply chain, student administration and others. The main reasons for PeopleSoft implementation are to improve workflow, reduce costs and to ensure reliable data management.

Because of the generic fashion that PeopleSoft's apps are developed in (in order to work on multiple vendor databases like Oracle, Sybase, Microsoft SQL Server and DB2), the SQL statements that data retrieval and data modification are done through are also generic. Therefore, not taking full advantage of the SQL statement processes that are unique to each database architecture, which then results in performance inefficiencies.

The main problem with database applications is that databases are dynamic environments, data volumes and user populations grow, new versions of
applications and databases are implemented, and server configurations change.

Quest SQL Optimizer for Oracle maximizes PeopleSoft's performance by focusing on those database factors that contribute up to 90% of performance problems: SQL statements, indexes, and database changes.

Using Quest SQL Optimizer and Quest's methodology for optimal performance in your PeopleSoft implementations and upgrades will: