Component : Database Administration with Oracle -

Solution : https://service.sap.com/sap/support/notes/439783 (SAP Service marketplace login required)

Summary :
During the execution of BRCONNECT for statistics calculation, warning BR986W may appear indicating an unbalanced index needing rebuild. This is often due to inappropriate settings of stats_change_threshold within init.sap, which if set too low, inaccurately judges an index as unbalanced based on rough statistical estimates. Additionally, inaccurate statistics calculations may exacerbate this issue. The recommended solution involves confirming if the index imbalance is genuine and adjusting the stats_change_threshold value to at least 20%. Enhancement of statistical precision or enabling table monitoring could resolve false warnings.

Key words :
terms br986w brconnect dbstatc unbalanced rebuild reason, alter table <tablename> monitoring/nomonitoring, analyze function calculates statistic values, obsolete statistic calculation procedures, calculated statistic values, statistic run fires, index statistic calculation, warningbr986w index <index>, 'index unbalanced' warning, table rows estimated

Related Notes :

771929	FAQ: Index fragmentation
408532	Using the DBMS_STATS package for collecting statistics