Lock types and duration during query processing  Locking for select queries at isolation Level 1

Chapter 2: Locking Overview

Lock types during create index commands

Table 2-14 describes the types of locks applied by Adaptive Server for create index statements:

Table 2-14: Summary of locks for insert and create index statements

Statement

Table Lock

Data Page Lock

Key: IX = intent exclusive, S = shared, X = exclusive

create clustered index

X

-

create nonclustered index

S

-



Copyright © 2003. Sybase Inc. All rights reserved. Locking for select queries at isolation Level 1

View this book as PDF