
|
Rebecca Scanlan |
Embarcadero DB Optimizer 2.0 Reduces the Complexity of SQL Tuning Visual SQL Tuning Diagrams and Index Analysis Features Accelerate Expert SQL Performance Decisions SAN FRANCISCO – Oct. 20, 2009 — 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 For a video demonstrating what’s new with DB Optimizer 2.0, please click here. Pricing and Availability About Embarcadero Technologies 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.
|
