How does BRCONNECT proceed when creating statistics?
In the usual scenario, BRCONNECT functions in two phases: a) First, it determines whether new statistics are required: New statistics are only required if the number of table entries since the last statistics creation has changed by more than one threshold value (parameter stats_change_threshold, default: 50%) BRCONNECT then creates new statistics: BRCONNECT 7.00 (36) and higher releases contain tables in which a Data Definition Language (DDL) operation has occurred such as online reorganization, SHRINK, or ADD COLUMN (see Note 1235952, point 2). b) Creating new statistics: If the first phase resulted in the need for new statistics, and the system has met further conditions (no alternative entry in the DBSTATC control table, no table pool or table cluster, and so on), new statistics are created.
Related Questions
- SAMPLE_SIZE <>24. How can I define additional exceptions to the standard procedure in creating statistics with BRCONNECT?
- How can I define additional exceptions to the standard procedure in creating statistics with BRCONNECT?
- Does BRCONNECT also support new 10g statistics features, such as locking statistics?
