视图和表之间的连接会影响性能吗? [英] Can Joins between views and table hurt performance?

问题描述

我是 sql server 的新手，

I am new in sql server,

我的经理给了我一份工作，我必须在 sql server 2008 中找出查询的性能.

my manager has given me job where i have to find out performance of query in sql server 2008.

该查询非常复杂，需要在视图和表之间进行连接.我在互联网上读到，视图和表之间的连接会导致性能受损?

That query is very complex having joins between views and table. I read in internet that joins between views and table cause performance hurt?

如果有专家可以帮助我吗?我在哪里找到了这方面的知识的任何好的链接?sql server中如何计算查询性能?

If any expert can help me on this? Any good link where i found knowledge of this? How to calculate query performance in sql server?

推荐答案

看看查询计划 - 它可以是任何东西.缺少基础视图表之一的索引、缺少连接表或其他内容的索引.

Look at the query plan - it could be anything. Missing indexes on one of the underlying view tables, missing indexes on the join table or something else.

看看 Gail Shaw 的这篇关于在 SQL Server 中查找性能问题的文章 - 第 1 部分，第 2 部分.

Take a look at this article by Gail Shaw about finding performance issues in SQL Server - part 1, part 2.

这篇关于视图和表之间的连接会影响性能吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！