Home>Article>Database> 看懂SqlServer查询计划

看懂SqlServer查询计划

WBOY Original: 2016-06-07 15:51:35 1320browse

欢迎进入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]

看懂SqlServer查询计划

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中的应用

See more

看懂SqlServer查询计划

Related articles