Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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
.gif "Download"){kind=icon}
OnlineIndex.doc
329 KB
Microsoft Word file
Get Office File Viewers