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


329 KB
Microsoft Word file
Get Office File Viewers