Why is it that frequently, only the primary indexes have new statistics after a BRCONNECT run?
To determine the current number of table entries in the check phase, BRCONNECT executes an ANALYZE of the primary index. This is much faster than accessing the (larger) table yourself. For this reason, the primary indexes always receive new statistics – even if it turns out that the table does not require any new statistics. The system deviates from the above rule if table monitoring is activated (Notes 408527, 628590). In this case, there is no need to analyze the primary index and as a result, the primary indexes do not receive any new statistics.
