开发者

If I create an index to a table in sql server, a view which looks indexed table will be affected?

I have a view and it looks a table. If I create an index for this table, view will be affected on this index? Th开发者_运维技巧anks for your help.


Yes, the view will be affected.

The view doesn't have an execution plan of itself, it will be included in the query that uses it, and a plan is made for the entire query, just as if you would paste the code from the view into the query.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜