Table 2-14 describes the types of locks applied by Adaptive Server for 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 |
- |