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

Chapter 10: Locking in Adaptive Server

Lock types during create index commands

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

Table 10-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 © 2002. Sybase Inc. All rights reserved. Locking for select queries at isolation Level 1

View this book as PDF