Hello,
we are preparing the update of our environments to version 8.1.5. In the development environment we have noticed that within the daily maintenance work not all table indexes are
being rebuilt. A look into the Relase Notes explained us why this is the case, there is to read the following
DBQueue Processor QBM-K-CommonReIndexTable tasks that reindex large tables do not disappear from the DBQueue. Reindexing of tables does not take place anymore if they are larger than 1 GB or have more than 1 million data records. Maintenance of these tables must be carried out by the database administrator within the maintenance period. (Issue-ID 33733)
Are there any best practices on how our database admins should proceed here, since this is probably handled differently by every application based on MSSQL?
Thanks for any hints.