你的位置: 码友网首页 / 资讯源列表 / Top things you need in a SQL Server query plan analysis tool

关于[Top things you need in a SQL Server query plan analysis tool]的摘要:

SQL Server query plans AKA execution plans are one of the greatest assets when it comes to tuning, optimizing, and troubleshooting our queries. Transact-SQL is a declarative language that can be used to query data without requiring a human interaction to specify an exact execution plan to be followed. This simply means that we are not telling SQL Server how to go and fetch the data, we’re just telling it what data we want it to get. So, think of an execution plan as a map. It is a map that the query optimizer is drawing that represents an efficient execution plan to retrieve the data.

原文地址: https://solutioncenter.apexsql.com/top-things-you-need-in-a-sql-server-query-plan-analysis-tool/

收录时间: 2018-07-15 浏览量: 2078 分类: SQL Server

| 0 收藏 | 0