Embarcadero DB Optimizer maximizes database performance by enabling developers and DBAs to quickly discover, diagnose, and optimize poor-performing SQL. DB Optimizer eliminates performance bottlenecks by discovering data intensive or frequently executed queries, focusing in on specific SQL statements through query statistics (CPU, I/O, wait times), and optimizing any problematic statements.

DB Optimizer offers:

• Graphical visualization of wait-time analysis to easily pinpoint the SQL causing poor database performance
• Hyperlinked drill-downs for locating detailed activity information for an individual SQL statement
• Explain plans for a better understanding of how SQL will be executed and the performance costs
• Real-time Quick Fixes to flag and correct inefficient SQL automatically (Oracle)
• Batch tuning of DML statements, stored routines, entire SQL files and the System Global Area (Oracle)

Wait time analysis gives you a complete performance profile from the end-user's point of view, making it possible to truly improve overall database performance. In addition, DB Optimizer incorporates Embarcadero PowerSQL Professional Edition, making it possible to develop, test, profile, and tune SQL in one easy-to-use application.

• Current Version: 1.0
• Prior Version:n/a
• Current Release: July 2008