If the query returns X$ tables, then fixed object statistics exist.17. Why do some tables not contain any new statistics even though a statistical run was carried out with BRCONNECT?
Before BRCONNECT creates new statistics, the tool checks whether new statistics are required. No new statistics are created if there have been no significant changes in the number of entries in a table.18. 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.19. How can I force the creation of statistics with BRCONNECT for a table? You can do this by additionally specifying the force options -f colle
Related Questions
- If the query returns X$ tables, then fixed object statistics exist.17. Why do some tables not contain any new statistics even though a statistical run was carried out with BRCONNECT?
- Why do some tables not contain any new statistics even though a statistical run was carried out with BRCONNECT?
- How can I determine whether Oracle DDIC tables contain statistics?
