Online Indexing Operations
One of the great features available with SQL Server 2008 is online indexing. This feature, available only with the Enterprise or Developer Edition, allows you to create, rebuild, or drop indexes without having exclusive access to the index or table. This means that users can have concurrent access to the underlying tables and indexes while the index operation is in progress. This bodes well for high-availability applications and databases that have limited downtime available for offline operations.
Following is an example of the T-SQL syntax for an online index operation:
The ONLINE = ON parameter is the key to making ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
