Database Knowledge Base
Search:     Advanced search
Browse by category:
Glossary | Contact Us
Database Knowledge Base / MS SQL Server / 2005 / what is ONLINE INDEX?

what is ONLINE INDEX?
Print
Email to friend
Add comment
Views: 367
Votes: 0
Comments: 0
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
Others in this Category
document What is Data Mapping
document What is an Ad Hoc Query?
document what is the method to change location of tempdb?
document How to know which index a table is using?
document Which Stored procedure will be used to create an alert in database?
document which clause specified while creating a stored procedure causes the stored procedure to recomplile every time it is run?
document Which stored procedure is used to change the password for the distributor?


RSS
Powered by KBPublisher (Knowledge base software)