SQL Server 相当于 MySQL 的 EXPLAIN [英] SQL Server equivalent to MySQL's EXPLAIN

问题描述

我正在阅读 SQL 教程，该教程使用关键字 EXPLAIN 来查看查询是如何执行的.我在 SQL Server 2008 中尝试过，但没有成功.

I was reading an SQL tutorial which used the keyword EXPLAIN to see how a query is executed. I tried it in SQL Server 2008 with no success.

如何获得等效结果?

推荐答案

我相信 EXPLAIN 关键字是一个 MySQL 概念 - 等效的 Microsoft SQL 服务器概念是执行计划.

I believe that the EXPLAIN keyword is an MySQL concept - the equivalent Microsoft SQL server concept is the execution plan.

获取执行计划的最简单方法是在 SQL Server Management Studio 中打开显示实际执行计划"菜单项(在查询菜单中).或者，您可以在此处阅读有关执行计划的更深入指南:

The simplest way of getting an execution plan is to turn on the "Show actual execution plan" menu item (in the query menu) in SQL server management studio. Alternatively you can read a more in-depth guide on execution plans here:

• http://www.simple-talk.com/sql/performance/execution-plan-basics/

本文详细介绍了什么是执行计划、如何获取执行计划以及不同的执行计划格式.

This article goes into a lot more detail on what execution plans are, how to obtain an execution plan, and the different execution plan formats.

这篇关于SQL Server 相当于 MySQL 的 EXPLAIN的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！