Search results are quicker when records are retrieved by the cluster index
other indexes that use fields that are a part of the cluster index might use less data space
It takes longer to update records if only when the fields in the clustering index are changed.
Avoid clustering index constructions where there is a risk that many concurrent inserts will happen on almost the same clustering index value
Last Wiki Answer Submitted: January 21, 2009 9:58 am by Denny Cherry64,505 pts.