调优SQL查询的步骤是什么？ [英] What are the steps to tune the SQL Queries?

问题描述

我有一个报告查询，如果我报告1个月，它会返回大量数据（大约20k）。但是查询本身花了很多时间来显示结果。查询包含很多子查询，我知道如果我们使用子查询，输出将是缓慢的。所以我已经将所有子查询更改为连接（主要是内连接，左连接）。仍然可以做一些调整。任何人都可以建议我如何调整SQL查询？请让我知道这些步骤。在什么方面我们可以提高SQL查询的性能？

I have a report queriy, which returns bulk of data( around 20k) if i take a report for 1 month. But the query itself is taking much time to show the result.The query contains lot of sub queries,i know if we use sub queries , the output will be in a slow manner. So i have changed all the sub queries to joins(mainly "Inner join","Left Join" ). Still there could be done some more tuning. Any one can suggest me how to tune the SQL queries? Please let me know the steps. In what are all the way we can improve the performance of SQL Queries?

推荐答案

参考这个.. :)



如何：优化SQL查询 [ ^ ]



SqlServer查询优化提示 [ ^ ]



查询优化提示 [ ^ ]



SQL Tuning / SQL Opti mization技术： [ ^ ]



SQL SERVER - 通过分析查询计划进行SQL查询优化的提示 [ ^ ]



优化的十大步骤SQL Server中的数据访问：第二部分（重新考虑TSQL并应用最佳实践） [ ^ ]



The Baker's Dozen：26 Optimizi的生产力提示ng SQL Server查询（第1部分，共2部分） [ ^ ]



SQL Server查询的提示，技巧和建议优化小组 [ ^ ]

refer this.. :)

How To: Optimize SQL Queries[^]

SqlServer Query Optimization Tips[^]

Query Optimization Tips[^]

SQL Tuning/SQL Optimization Techniques:[^]

SQL SERVER – Tips for SQL Query Optimization by Analyzing Query Plan[^]

Top 10 steps to optimize data access in SQL Server: Part II (Re-factor TSQL and apply best practices)[^]

The Baker’s Dozen: 26 Productivity Tips for Optimizing SQL Server Queries (Part 1 of 2)[^]

Tips, Tricks, and Advice from the SQL Server Query Optimization Team[^]

这篇关于调优SQL查询的步骤是什么？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！