SQL Inspect

Category
Business
Applications

Review

SQL Inspect is a SQL editor for SQL Server, created with the aim of allowing users to quickly analyze a sub-optimal query, the tables and indexes used by that query, and record all results of rewriting the query. It offers the following features over standard SQL editor tools: Get an overview of a querys' cost instantly - View a summary of the querys' I/O costs. - View execution plans in a treeview and see costly operations highlighted. - Know when statistics need updating, as differences in estimated and actual rows are highlighted. - See which tables are incurring the most reads. - Know when SQL Server is raising warnings when generating your execution plans. - Easily identify from which table each column is originating from. Know which tables and indexes are used in a query - Quickly know which tables are used in a query. - Know how big each of those tables are. - Also see which indexes are used, together with all indexes that exist for all tables used in the query. - Know the size and fragmentation level of each of those indexes. - Filter indexes to know which indexes cover or include a specific column. Compare your queries against a baseline query - Set a baseline query, and immediately see how your rewritten queries compare against the baseline. - Quickly know when your new queries are better than the baseline and when they are worse, and in which areas. Keep a log of your optimization attempts - Quickly know the costs of each query you have attempted in comparison to the baseline. - View the differences in how the queries were written. - Keep a record of each querys' execution plan. - Save the log for future analysis. View statistics and fragmentation information easily - The integrated object browser allows you to view details of all statistics for a table, together with table and index fragmentation details. - Integrated wizards help you to update statistics and defragment tables and indexes easily.


Search

Recent searches