Are Locks Set During Create Index?

1.	Are Locks Set During Create Index?
Answer» 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. 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:

Answer»

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.

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:

Discussion