Locking During Index Creation

Posted in 1999

Bob Damato — Wed, 29 Sep 1999 14:00:54 GMT — source: Informix-list mailing list archive (1991-1998)

I've been digging around in the manuals and can't seem to find what type of locking occurs during creation of clustered and nonclustered indexes. Anyone know? bobd

↪ replying to Bob Damato

Art S. Kagel — Wed, 29 Sep 1999 13:27:15 -0400 — source: Informix-list mailing list archive (1991-1998)

Bob Damato wrote: > > I've been digging around in the manuals and can't seem to find what type > of locking occurs during creation of clustered and nonclustered indexes. > Anyone know? Building any index requires an Exclusive Table Level lock. Art S. Kagel