Error 1250126: Database Studio

To set a bookmark to this detailed view right-click here

Message Data

Reported

Settlement

Delivered

 
79.09.00 Delivered 79.09.07  

Created

Processed

Completed

Affected OS

2013-02-07 2018-02-23 2018-02-23 All

Message Texts

Description Solution Patch Information Links

Description

Top
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.
 

Solution

Top
Commit added after "drop index" in "recreate index" case
 

Patch Information

Top

 

Links

Top

Id

Type

Description

Settlement

Planned Delivery

   1250127 Error Recreation of bad indexes via Index Wizard in Database Studio does not finish th... 78.02.43 5   
   1250128 Error Recreation of bad indexes via Index Wizard in Database Studio does not finish th... 77.07.52 5   
   1250129 Error Recreation of bad indexes via Index Wizard in Database Studio does not finish th... 79.08.42 5   
   1255313 Error Recreation of bad indexes via Index Wizard in Database Studio does not finish th... 79.10.00 4   
 
  Close Window     Help