更新时间:2023-02-08 15:46:25
考虑以下内容
Sql Azure需要群集索引来执行复制.注意,索引不必是唯一的. http://blogs.msdn.com/b/sqlazure/archive/2010/05/12/10011257.aspx
聚簇索引的优势在于,索引的范围查询是通过最少的寻道来***执行的.
The advantage of a clustered index is that range queries on the index are performed optimally with minimum seeks.
聚集索引的缺点是,如果以不按顺序的顺序添加数据,则可能会发生页面拆分,并且插入速度可能会相对较慢.
The disadvantages of a clustered index is that, if data is added in out of sequence order, page split may occur and inserts may be relatively slower.
参考以上内容,我建议以下内容
Referencing the above, I suggest the following