发表于2004/10/19 17:16:00 1219人阅读
Query Analyzer Tool (QAT) functions similarly to the standard SQL Server Query Analyzer application. The main feature of QAT is that it allows you to view plans in a hierarchical tree and save them for future reference.
It is often the case that when you are analyzing the execution plans of a complex query, the graphical plan in Query Analyzer becomes unusable due to its size, unless you have a very large display. QAT displays plans in a hierarchical tree, and highlights immediately the 5 most costly processes. In addition, you can save the plan and compare them with the plans of other queries later.
QAT has other features that aim to assist you in writing/optimizing SQL queries, among them:
- An index analysis screen that displays all the indexes of a table and allows you to quickly see what columns are indexed, and in which index they are in.
- A simple SQL parser to determine what tables are used in a query and the number of rows in each table.
- An editor that allows you to place up to 10 bookmarks, and quickly jump to individual bookmarks using keyboard shortcuts.
- An editor that locates matching braces. Just place your cursor before an opening or closing brace, hit F4, and QAT will move the cursor to the corresponding closing or opening brace.
- A results panel that allows you to export most data to Excel files, comma delimited files or plain text files.
- A results panel that allows you to sort most columns locally, without having you to submit the query again to the server with an ORDER BY column
- A columns panel that lists out all columns returned by the query and their data type.
- A results comparison feature that can highlight the differences between two result sets.
- A simple object browser for tables and views. Displays number of rows, size and columns of tables/views.
ms sql 2005 完整卸载,含工具
xz876513579 2015-03-30 10:13 341
windsp 2009-06-10 13:48 9
david_520042 2012-08-27 00:24 1951
chenxh 2006-02-23 09:05 110
ms SQL 和 sql anywhere 数据库管理实用工具源码
chenxh 2006-02-23 09:05 47
david_520042 2012-02-17 07:58 1201
mysql、MS SQL关于分页的sql查询语句 limit 和row_number() OVER函数
funi16 2012-10-10 16:51 8266
MS SQL 查询数据库中所有索引以及对应的表字段 SQL Server Profiler性能跟踪
qxyywy 2014-06-18 11:36 798