Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sona
Yak Posting Veteran
68 Posts |
 Posted - 2001-11-05 : 23:19:19
|
| Like i have 4 fields a primary key in my table.When i delete some rows with some condition,It takes a lot of time.Will the table be locked while deleting because insertions will also occur parallely in the mean time. Also i want to know what happens exactlyin the following situationsWill the whole index will be reordered everytime after a single row deletion or after a batch of deletion. |
|
|
|
|
|
index