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 Server概念是执行计划.

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屋！