一款MS SQL查询分析工具(1.3M)
来源:互联网 发布:post请求数据gzip加密 编辑:程序博客网 时间:2024/06/15 17:12
http://www.yohz.com/product_qat.html
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查询分析工具(1.3M)
- ms sql 高级查询
- MySQL、MS SQL、Oracle三种数据库查询M到N行数据
- 一款.net性能分析工具
- MS-sql实现分组查询
- ms sql汉字首字母查询
- MS SQL常用查询汇集
- [MS SQL]实用SQL查询语句集锦
- 推荐一款T-SQL代码格式化工具
- MS SQL Server查询优化方法
- [收藏]MS SQL Server查询优化方法
- MS-SQL的子查询表达式(1)
- MS SQL Server查询优化方法[摘]
- MS SQL Server查询优化方法
- MS SQL Server查询优化方法
- MS SQL Server查询优化方法
- MS-SQL Server 常用查询语句
- MS SQL server分布式查询(链接数据库)
- 深入解读 ADO.NET2.0的十大最新特性
- NTA终于发了第一个release
- .NET 中基于internet的部署
- ASP分页显示详论
- 在asp.net 中实现只允许数字输入的文本框
- 一款MS SQL查询分析工具(1.3M)
- c++编程习题与解答笔记(chapter 1)(全美经典学习指导系列)
- QQ开发资料
- ASP.NET 对文件的操作
- 特别关注:侯捷老师2004“程序人生”大陆巡讲
- ASP.NET 如何操作文件
- 关于企业及时通系统中短信中心模块的分析
- 简单的XML留言板
- 任意类成员函数作为线程参数的封装