DB Optimizer improves SQL Tuning

Released: Oct 2, 2013

Updates in this release

Updates in XE4

  • Identify Performance Bottlenecks Immediately - Database profiling provides a graphical visualization of wait-time analysis, making the SQL causing poor database performance easy to pinpoint.
  • Tune SQL like a Pro - The SQL tuning wizard automatically suggests solutions and provides essential contexts for tuning SQL code. Color-coded Index Analysis shows used, not used or missing indexes and offers recommendations for optimum performance.
  • Visually Tackle Complex SQL Queries - Visual SQL Tuning (VST) diagrams turn text-based SQL code into graphical SQL diagrams.
  • Simulate Production Environments - Load testing verifies performance of existing and alternative SQL queries against the database.
  • Become Proactive in Data Governance Compliance - DB Optimizer's ability to identify bottlenecks via database profiling, tune SQL and load test gives organizations an advantage in ensuring database optimization, uptime and availability.