So far, the values of the clustering key were sequential. What happens if they are not?
- 15. Implementing Indexes and Statistics
- from Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
- Publisher: Microsoft Press
- Released: December 2012
If the values in the clustering key are not sequential, SQL Server will have to do multiple page splits as the values are entered into the index which will lead to greater fragmentation.
Share this highlighthttp://www.safaribooksonline.com/a/training-kit-exam/72752/