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

-