聚簇索引和非聚簇索引之间的区别? [英] Difference between clustered and non clustered indexes?

问题描述

我已经阅读了很多有关聚簇索引和非聚簇索引的文章，但仍然无法找到这些索引的内部工作.因此，请提供最佳的解决方案.
在此先感谢

i have read a lot of articles about clustered and non clustered indexes but still i am not able to find out an internal working of these indexes.So kindly provide the best solution.
thanks in advance

推荐答案

如果记录的数量很少，那么就不需要索引了，真正的挑战始于1.您拥有庞大的数据库，而2应用程序和数据库之间的关系.两种方法都需要在性能和性能之间进行权衡.最好的解决方案是来自性能测试的解决方案. 基础 [

if the number of records is small then there is no need for indexes, the real challenge begins when 1. you have a huge data base and 2. the relation between application and database. Both methods are trade off between performance and performance. The best solution is the solution coming from performance tests. Basics[^]

这篇关于聚簇索引和非聚簇索引之间的区别?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！