Embarcadero DB Optimizer 2.0 Reduces the Complexity of SQL Tuning

Share Article

Visual SQL Tuning diagrams and Index Analysis features accelerate expert SQL performance decisions.

DB Optimizer 2.0 allows users to tune SQL at an expert level, ultimately maximizing database and application performance.

Embarcadero, a leading provider of multi-platform database tools and developer software, is adding more graphical capabilities to DB Optimizer to make it easier for developers and DBAs to do SQL profiling and tuning.

With the new DB Optimizer 2.0, Embarcadero is innovating on the SQL tuning front by incorporating graphical tools like the Visual SQL Tuning (VST) diagram and the Index Analysis feature that allow developers to quickly understand the components of a SQL query and DBAs to make faster at-a-glance decisions.

"SQL is becoming an essential language for developers, and with assistance from the right tools, they can confidently own more of the SQL performance tuning process to ensure the code they pass to the QA engineer and DBA is fully optimized," said Greg Nerpouni, senior product manager of developer solutions for Embarcadero. "DB Optimizer 2.0 allows users to tune SQL at an expert level, ultimately maximizing database and application performance."

DB Optimizer 2.0 takes SQL tuning beyond standard hint injections and SQL rewrites by offering advanced features such as VST diagrams and Index Analysis.

The new VST diagram displays indexes and constraints on tables and views, as well as the joins used in a SQL statement. This helps developers and DBAs see potential flaws in the schema design such as Cartesian joins, implied Cartesian joins and many-to-many relationships, accelerating trouble-shooting and analysis.

With the new Index Analysis feature, DBAs and developers can fully examine SQL execution paths to better understand which indexes are used, not used, or missing. If an index is missing, DB Optimizer 2.0 offers indexing recommendations for optimum performance.

"These new features help support a best-practices approach to troubleshooting performance issues and optimizing SQL code," added Nerpouni.

About DB Optimizer
DB Optimizer is an easy-to-use, easy to install SQL profiling and tuning IDE that supports IBM® DB2® for LUW, Oracle®, Microsoft® SQL Server and Sybase®. DB Optimizer helps eliminate performance bottlenecks by identifying data intensive or frequently executed queries, focusing on specific SQL statements through query statistics (CPU, I/O, wait times), and fine-tuning problematic statements.

For a video demonstrating what's new with DB Optimizer 2.0, please visit http://altd.embarcadero.com/download/video/DBO/dbo-20-sql-task-analyzer.mp4.

Pricing and Availability
Embarcadero DB Optimizer 2.0 is now available worldwide as a standalone tool or as part of the Embarcadero All-Access tool chest. North American pricing begins at $1,500 per license. For more information, visit http://www.embarcadero.com/products/db_optimizer.

About Embarcadero Technologies
Embarcadero Technologies, Inc. is a leading provider of award-winning tools for application developers and database professionals so they can design systems right, build them faster and run them better, regardless of their platform or programming language. Ninety of the Fortune 100 and an active community of more than three million users worldwide rely on Embarcadero products to increase productivity, reduce costs, simplify change management and compliance and accelerate innovation. Founded in 1993, Embarcadero is headquartered in San Francisco, with offices located around the world. Embarcadero is online at http://www.embarcadero.com.

Embarcadero, the Embarcadero Technologies logos and all other Embarcadero Technologies product or service names are trademarks or registered trademarks of Embarcadero Technologies, Inc. All other trademarks are property of their respective owners.


Share article on social media or email:

View article via:

Pdf Print

Contact Author

Visit website