Indexing while updating
Posted: Fri Nov 08, 2002 1:49 pm
Is there a way to let updates to a table happen while a btree index is being built???
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 ...."