Statistics are retained during an Oracle and R/3 upgrade and do not have to be recreated.36. How are statistical values included in the CBO cost calculation?
Note 750631 describes rules of thumb for the cost calculation of typical database accesses based on parameters and statistics.37. Why does DB20 report statistics as obsolete, even if they have just been created? DB20 compares the current number of rows in the table with the number of the rows the last time the statistics were created. If the difference between these numbers exceeds a defined threshold value (default value is 50%), the statistics are regarded as obsolete. To estimate the current number of table entries, an analysis of the primary index is performed with the default statistics accuracy. If the accuracy is low or the index is heavily fragmented, the estimated result deviates significantly from reality and DB20 reports obsolete statistics, even though the statistics are current. In most cases, reconstructing the index (see Note 332677) or creating the statistics with greater accuracy helps in this case.38. Can I use Oracle tools such as DBMS_STATS instead of BRCONNECT for
