Indexing while updating

Post Reply
MiniMe
Posts: 210
Joined: Thu Mar 15, 2001 4:30 pm

Indexing while updating

Post by MiniMe »

Is there a way to let updates to a table happen while a btree index is being built???
User avatar
Kai
Site Admin
Posts: 1271
Joined: Tue Apr 25, 2000 1:27 pm

Indexing while updating

Post by Kai »

Nope. Regular (B-tree) index creates require write-locking the table for the duration of the create. In recent (after August 2002) versions, you can set indexmeter=1 before creating the index to watch its progress:

tsql "set indexmeter=1; create index ...."
Post Reply