Database Knowledge Base

Add comment
Name:
Email:
* Comment:
(Use BBcode - No HTML)
code
* Confirmation code:   Write the characters in the image above exactly as you see it


what is ONLINE INDEX?

Online Index is a feature available after SQL Server 2005, prevously DBAs had to build index during off-peak hours as SQL Server locks data for exlusivly during building of index.

using Online Index the index operations on the underlying table can be performed concurrently with update or query operations. This was not possible in previous versions of SQL Server.

This functionality only avialble in Enterprise Edition of SQL Server 2005



RSS