|
Recreation of bad indexes via Index Wizard in Database Studio does not finish the DROP INDEX action with a COMMIT. This way all
indexes which are bad are created 'BLOCKING' although they could be created 'NON-BLOCKING'. This way it is impossible to work in parallel
with a table (insert, delete) the index is created for.
Furthermore it could be considered to use the DBM command sql_recreateindex for recreation of bad indexes.
|
|