SQL Server中的聚集索引和非聚集索引有什么区别？
Indexes are used to speed-up query process in SQL Server, resulting in high performance. They are similar to textbook indexes. In textbooks, if you need to go to a particular chapter, you go to the index, find the page number of the chapter and go directly to that page. Without indexes, the process of finding your desired chapter would have been very slow.
索引用于加快SQL Server中的查询过程，从而提高性能。 它们类似于教科书索引。 在教科书中，如果需要转到特定的章节，请转到索引，找到该章节的页码，然后直接转到该页面。 没有索引，查找所需章节的过程将非常缓慢。
The same applies to indexes in databases. Without indexes, a DBMS has to go through all the records in the table in order to retrieve the desired results. This process is called table-scanning and is extremely slow. On the other hand, if you create indexes, the database goes to that index first and then retrieves the corresponding table records directly.
这同样适用于数据库中的索引。 没有索引，DBMS必须遍历表中的所有记录才能检索所需的结果。 此过程称为表扫描&#x
Indexes are used to speed-up query process in SQL Server, resulting in high performance. They are similar to textbook indexes. In textbooks, if you need to go to a particular chapter, you go to the index, find the page number of the chapter and go directly to that page. Without indexes, the process of finding your desired chapter would have been very slow. 索引用于加快SQL Server中的查询过程，从而提高性能。 它们类似于教科书索引。 在教科书中，如果需要转到特定的章节，请转到索引，找到该章节的页码，然后直接转到该页面。 没有索引，查找所需章节的过程将非常缓慢。 The same applies to indexes in databases. Without indexes, a DBMS has to go through all the records in the table in order to retrieve the desired results. This process is called table-scanning and is extremely slow. On the other hand, if you create indexes, the database goes to that index first and then retrieves the corresponding table records directly. 这同样适用于数据库中的索引。 没有索引，DBMS必须遍历表中的所有记录才能检索所需的结果。 此过程称为表扫描&