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 Maximum Number of Columns a Table in SQL Server ?

How to Restart SQL Server in Single-User Mode ?

What is the Difference Between a Local and a Global Temporary Tab ...

How is Auditing Different From Change Data Capture in SQL Server?

How to Learn MS SQL Server Version