表中的非集群索引的用途是什么 [英] what is the use of non clusters index in a table

问题描述

表中非聚集索引的用途是什么？

解决方案

来自MSDN



< blockquote class =quote>

Quote：

非聚集索引是一个索引结构，与存储在表中的数据分开，该表重新排序一个或多个选定的列

1.非聚簇索引通常可以帮助您比搜索基础表更快地找到数据

2.非聚簇索引可以将数据库引擎指向基础表中的行

3.创建非聚簇索引以提高聚簇索引未涵盖的常用查询的性能，或者在没有聚簇索引的情况下查找表中的行



阅读更多

What is the use of non clustered index in table?

解决方案

From MSDN

Quote:

A nonclustered index is an index structure separate from the data stored in a table that reorders one or more selected columns

1. Nonclustered indexes can often help you find data more quickly than searching the underlying table
2. The nonclustered index can point the Database Engine to the rows in the underlying table
3. Nonclustered indexes are created to improve the performance of frequently used queries not covered by the clustered index or to locate rows in a table without a clustered index

Read more

这篇关于表中的非集群索引的用途是什么的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！