Question - Are Locks Set During Create Index?
Answer -
Are Locks Set During Create Index?
Yes. Up to and including SAP MaxDB Version 7.6, a lock is set on the relevant tables during the index creation.
As of SAP MaxDB Version 7. 7, the system sets a lock for the entire duration of the index creation only if the following conditions apply:
- if it is a UNIQUE index
- if the transaction that executes the CREATE INDEX statement has already set other locks.