- Learn T-SQL Querying
- Pedro Lopes Pam Lahoud
- 194字
- 2021-06-24 14:38:11
Understanding Query Processing
Now that we have learned the basics of writing T-SQL queries and how SQL Server interprets them, the next logical step is to understand how SQL Server processes and ultimately executes the query. The Query Processor includes query compilation, query optimization, and query execution essentials; how does SQL Server compile an incoming T-SQL statement? How does SQL Server optimize and execute a T-SQL statement? How does SQL Server use parameters? Are parameters an advantage? Why does a SQL Server cache execution plans for certain T-SQL statements but not others? When is that an advantage and when is it a problem? This is information that any T-SQL practitioner needs to keep as reference for proactive T-SQL query writing, as well as reactive troubleshooting and optimization purposes. This chapter will be referenced throughout all chapters, as we bridge architectural topics to real-world usage. The main stages of query processing can be seen in the following overview diagram, which we will expand on throughout this chapter:

In this chapter we will cover the following topics:
- Query compilation essentials
- Query optimization essentials
- Query execution essentials
- Plan caching and reuse
- The importance of parameters
- 課課通計算機(jī)原理
- 計算機(jī)圖形學(xué)
- 輕松學(xué)Java Web開發(fā)
- Visual C# 2008開發(fā)技術(shù)詳解
- 可編程控制器技術(shù)應(yīng)用(西門子S7系列)
- CentOS 8 Essentials
- 內(nèi)模控制及其應(yīng)用
- 分析力!專業(yè)Excel的制作與分析實用法則
- Photoshop行業(yè)應(yīng)用基礎(chǔ)
- Learning Linux Shell Scripting
- 電動汽車驅(qū)動與控制技術(shù)
- ADuC系列ARM器件應(yīng)用技術(shù)
- Flash CS3動畫制作融會貫通
- 歐姆龍CP1系列PLC原理與應(yīng)用
- 站酷志:資深設(shè)計師的Photoshop創(chuàng)意課