What are visual SQL tuning diagrams?

by Dec 13, 2018

SQL queries are the primary mechanism to interact with databases. Therefore, ensuring that SQL queries perform well is essential. An important method to improve the performance of SQL queries is to use indexes properly to locate data quickly. To create useful indexes, it is essential to understand how databases store data versus what type of data SQL queries need to access.

Visual SQL tuning refers to parsing an SQL query, analyzing the indexes and constraints on the tables in the SQL query, and displaying the SQL query represented as relational models in diagrams. Visual SQL tuning helps see flaws in designs of schemas (such as Cartesians joins, implied Cartesians joins, and many-to-many relationships). The visual SQL tuning diagram also helps to understand more quickly the components of an SQL query, thus accelerating troubleshooting and analysis.

View the infographic "Visual SQL Tuning Diagrams" to learn why tuning SQL queries is important, why SQL queries can be sub-optimal, how to improve SQL query performance, five steps for efficient SQL tuning, components of SQL query analysis, what information to display, and the benefits of SQL tuning diagrams.

Click here to view the infographic.

SQL Query Tuner is an automated SQL query optimization tool that maximizes database and application performance by quickly discovering, diagnosing, and optimizing poor-performing SQL queries. It empowers database administrators and database developers to eliminate performance bottlenecks by graphically profiling critical metrics inside the database, relating resource utilization to specific queries, and helping to tune problematic SQL queries visually. Read the datasheet, watch the overview video, and start a fully functioning 14-day trial.

SQL Query Tuner is an add-on to SQL Diagnostic Manager that is part of SQL Diagnostic Manager Pro. Read the datasheet of SQL Diagnostic Manager Pro and view a comparison of the two editions of SQL Diagnostic Manager. Download a fully functioning 14-day trial of SQL Diagnostic Manager, start a request a one-on-one demonstration, or request a price quotation.