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.