mcsd 70-029 试题疑问之十一???

[RickeyLv]

The WHERE clause of query includes Search on Column A, Column B, Column C. Column A is nearly identical in all row. Column B is identical in about 50% of the row, Column C is indetical in about 10% of the row. How should you create indexes?
A. Create composite clustered index on Column A, Column B, Column C.
B. Create composite clustered index on Column C, Column B, Column A.
C. Create composite nonclustered index on Column A, Column B, Column C.
D. Create composite nonclustered index on Column C, Column B, Column A.
E. Create composite clustered index on Column A, separated nonclustered index on Column B & Column C.
F. Create separated nonclustered index on each column.
Answer: B or d ??????

[freezwy]

clustered 聚集索引,是指如果索引后,在表中的存储位置就是按你索引的排列
nonclustered 则是按常规存储,只是结果按索引的来
所以分析nearly,50%,10%就可以确定不用聚集索引了,因此选d

[RickeyLv]

我也觉得是，给分

[Regen219]

对！