|
Home > Archive > MS SQL Server > November 2006 > For non-serialized does key lock lock more than one row?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
For non-serialized does key lock lock more than one row?
|
|
| Randolph Neall 2006-11-29, 7:12 pm |
| For Sql 2000, for isolation levels not serialized, can a key lock
(especially created by an inserted row), involving a nonprimary key index
end up locking more than one row?
Thanks,
Randy Neall
| |
| David Browne 2006-11-29, 7:12 pm |
|
"Randolph Neall" < randolphneall@veraci
tycomputing.com> wrote in message
news:#GWEwT8EHHA.3780@TK2MSFTNGP02.phx.gbl...
> For Sql 2000, for isolation levels not serialized, can a key lock
> (especially created by an inserted row), involving a nonprimary key index
> end up locking more than one row?
>
Since each key in a non-unique index may relate to multiple rows, a key lock
on a non-unique index typically impacts multiple rows, since The rows
themselves are not locked, but the key lock will be inconsistent with any
other transaction reading or locking that index key. So it may well block
other operations on other rows that share that index key.
David
| |
| Randolph Neall 2006-11-30, 7:14 pm |
| Thanks, David.
Randy
"David Browne" <davidbaxterbrowne no potted meat@hotmail.com> wrote in
message news:OsJQ508EHHA.3780@TK2MSFTNGP02.phx.gbl...
>
>
> "Randolph Neall" < randolphneall@veraci
tycomputing.com> wrote in message
> news:#GWEwT8EHHA.3780@TK2MSFTNGP02.phx.gbl...
index[color=darkred]
>
> Since each key in a non-unique index may relate to multiple rows, a key
lock
> on a non-unique index typically impacts multiple rows, since The rows
> themselves are not locked, but the key lock will be inconsistent with any
> other transaction reading or locking that index key. So it may well block
> other operations on other rows that share that index key.
>
> David
>
|
|
|
|
|