如何减少运行SQL SERVER 2005查询的执行时间？ [英] How can i reduce the execution time of running a query of SQL SERVER 2005?

问题描述

如何减少运行SQL SERVER 2005查询的执行时间？

How can i reduce the execution time of running a query of SQL SERVER 2005?

推荐答案

使用SQL事件探查器创建和更改索引以获得更好的性能： br />
http://msdn.microsoft.com/en-us/library/ff650699 .aspx [ ^ ]



SQL Server Profiler Step by Step [ ^ ]

Use the SQL Profiler to create and change indexes for better performance :
http://msdn.microsoft.com/en-us/library/ff650699.aspx[^]

SQL Server Profiler Step by Step[^]

取决于很多因素：

- 子查询数，

- 变量数，

- 要做的操作次数，

- JOIN数量，

- 硬件性能。



参考以下链接：

如何：优化SQL查询 [ ^ ]

Microsoft T-SQL性能调优第3部分：分析和优化Microsoft SQL上的T-SQL查询性能服务器使用查询优化器策略 [ ^ ]

7个更快速SQL查询的性能提示 [ ^ ]

Seven Sins vs TSQL Performance [ ^ ]

比较查询性能 [ ^ ]



搜索CP知识库以了解更多信息。

It depends on many factors:
- count of subqueries,
- count of variables,
- count of operations to do,
- count of JOINs,
- hardware performance.

Refer below links:
How to: Optimize SQL Queries[^]
Microsoft T-SQL Performance Tuning Part 3: Analyzing and Optimizing T-SQL Query Performance on Microsoft SQL Server using Query Optimizer Strategies[^]
7 performance tips for faster SQL queries[^]
The Seven Sins against TSQL Performance[^]
Comparing Query Performance[^]

Search CP knowledge base to find out more.

这篇关于如何减少运行SQL SERVER 2005查询的执行时间？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！