| Query Type | Table Lock | Page Lock |
|---|---|---|
| Insert | IX | X |
| Update using index/SARG | IX | U,X |
| Delete using index/SARG | IX | X |
| Update w/o using index/SARG | X | _______ |
| Delete w/o using index/SARG | X | _______ |
| Select using index | IS | S |
| Select using index w/holdlock | IS | S |
| Select w/o using index (no holdlock) | IS | S |
| Select w/o using index (holdlock) | S | _______ |
| Create clustered index | X | _______ |
| Create non-clustered index | S | _______ |
KEY:
I = intent lock
S = shared lock
X = exclusive lock
U = update lock