看懂SqlServer查询计划
- WBOYOriginal
- 2016-06-07 15:51:351371browse
欢迎进入Windows社区论坛，与300万技术人员互动交流 >>进入 再来一个由三个查询组成的情况来看看这个视图的执行计划。 select * from dbo.OrdersView where OrderId = 1; select * from dbo.OrdersView where CustomerId = 1; select * from dbo.OrdersView
欢迎进入Windows社区论坛，与300万技术人员互动交流 >>进入
再来一个由三个查询组成的情况来看看这个视图的执行计划。
select * from dbo.OrdersView where OrderId = 1;
select * from dbo.OrdersView where CustomerId = 1;
select * from dbo.OrdersView where OrderDate >= '2010-12-1' and OrderDate
很明显，对于同一个视图，在不同的过滤条件下，执行计划的差别很明显。
[1] [2] [3] [4]
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：sqlserver 中group by的用法Next article：B-Tree索引在sqlserver和mysql中的应用