1、索引不能创建在超过900bytes的字段上
若强行创建会提示
Warning! The maximum key length is 900 bytes. The index 'IX_test_tony_col1' has maximum length of 1000 bytes. For some combination of large values, the insert/update operation will fail.
此时会创建成功,但若插入超过900宽度的内容就会插入失败,并提示一下错误
Msg 1946, Level 16, State 3, Line 2
Operation failed. The index entry of length 990 bytes for the index 'IX_test_tony_col1' exceeds the maximum length of 900 bytes.
2、聚合索引应该尽量建立在int类型的identity列上
因为
<1>所有的非聚合索引都要应用主键做书签查找,应该足够短,且唯一。若不唯一SQL会为索引重复键值 的每行自动增加一个叫uniquifier的东西使得每一行唯一,这个uniquifier对客户端是透明的。这会增加额外的负担&#