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

-