解决方法
是的,基础表索引被自动使用 – 一个视图完全从底层表中提取数据.
关于在视图上创建索引的好处,请参见this MS Technet article.小摘录:
Using indexes to improve query
performance is not a new concept;
however,indexed views provide
additional performance benefits that
cannot be achieved using standard
indexes. Indexed views can increase
query performance in the following
ways:
- Aggregations can be precomputed and stored in the index to minimize
expensive computations during query execution.- Tables can be prejoined and the resulting data set stored.
- Combinations of joins or aggregations can be stored.