Online Indexing Operations in SQL Server 2005
Introduced in SQL Server 2005 Enterprise Edition, the online index feature provides a powerful way to perform maintenance operations such as rebuilding or creating indexes in a production system without sacrificing DML concurrency. This paper provides a detailed discussion of the index process and provides guidelines and best practices for implementing this feature in a production environment.
Included in this document:
-
Introduction
-
Data Structures and Concepts
-
Overview of the Online Index Build Algorithm
-
Capacity Planning and Concurrency Considerations for Index Create and Rebuild Operations
-
Online Index Best Practices
-
Conclusion
-
Appendix A: Performance Study
-
Appendix B: Diagnostics
-
Appendix C: Log Measurement Script
-
Appendix D: Online Index Limitations
Download
OnlineIndex.doc
329 KB
Microsoft Word file
Get Office File Viewers