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

Chapter 1: Introduction to Locking

Lock types during create index commands

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

Table 1-14: Summary of locks during create index statements

Statement

Table lock

Data page lock

Key: S = shared, X = exclusive

create clustered index

X

-

create nonclustered index

S

-



Copyright © 2011. Sybase Inc. All rights reserved. Locking for select queries at isolation level 1

View this document as PDF