如何在sqlserver中应用索引 [英] How To apply Indexing in sqlserver
本文介绍了如何在sqlserver中应用索引的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何在视图上应用索引?
How Can I Apply Indexing on View ?
推荐答案
请参见 ^ ].
如果愿意,您可以创建索引视图
http://technet.microsoft.com/en-us/library/cc917715.aspx [ ^ ]
但是,除了Data Warehouse类型的解决方案外,我通常会避免使用它们.他们有自己的位置,但是您需要了解可能的问题
http://blogs.msdn.com/b/microsoftbob/archive/2009/08/15/cautions-with-indexed-views.aspx [
You can create an Indexed View if you like
http://technet.microsoft.com/en-us/library/cc917715.aspx[^]
However, for anything other than Data Warehouse type solutions I''ve generally avoided them. They have their place, but you need to understand possible issues
http://blogs.msdn.com/b/microsoftbob/archive/2009/08/15/cautions-with-indexed-views.aspx[^]
Correct indexing of your tables used by the view will usually give you the performance you want
请不要相信上面的链接,很多人误导了初级用户答案是绝对不可以的:rose:
please don''t trust above links there are many people who misguide juniors answer is absolutely NO :rose:
这篇关于如何在sqlserver中应用索引的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文