What is an Online Rebuilding of Indexes in SQL Server ?

Online operation means when online operations are happening the database is in normal operational condition, the processes which are participating in online operations does not require exclusive access to a database.

In the case of Online Indexing Operations, when Index operations (create, rebuild, dropping) are occurring they do not require exclusive access to a database, they do not lock any database tables. This is a major important upgrade in SQL Server from previous versions.



You May Interest

What is the Difference Between Update Lock and Exclusive Lock in ...

Using CASE WHEN in MS SQL

MS SQL List of Records in All Tables

Getting List of All Views in MS SQL Database

What is the Filtered Index in SQL Server ?