SQL Server 2000, Non-Clustered Index Creation and Blocking
in [Programming SQL]
|
Prev: SQL Server 2000, Non-Clustered Index Creation and Blocking
Next: sqlcrl exception >> attn Charles Wang <<
From: John Couch on 19 Apr 2010 12:09 I have tried to test this, but even with 30 million records int he table the index is created so fast that executing the query and hitting an sp_who2 isn't either showing a block, or there isn't one at all. Does anyone know if creating a non-clustered index is a blocking operation? I was thinking it might be if the index was being created on the same fields the where clause was querying on. Unless the create nonclustered index statement uses a nolock statement on the values. Any help would be great. thanks. |