Sap update oracle statistics

Alternatively, call transaction DB Enter the name of the table in Table do not enter a generic name or pattern and choose Refresh information to display information about current table statistics. The system displays a status message and a color-coded status indicator for the displayed table:. The update statistics method to be used the next time update statistics runs:.

E Estimate table statistics including indexes. EH Estimate table statistics and create histograms. EI Estimate table statistics and verify index structure. EX Estimate table statistics, create histograms, and verify index structure. C Compute table statistics including indexes.

CH Compute table statistics and create histograms. CI Compute table statistics and verify index structure. CX Compute table statistics, create histograms, and verify index structure. O optimizer Only for the optimizer standard setting.

Control flag, indicating if and how the statistics are updated or created, and in which context they are used. Otherwise, it uses the rule-based optimizer. Since from Oracle 10g the rule-based optimizer is no longer supported, in this case auto-sampling is performed. Update statistics supports partitioned tables. For more information, see SAP Note Each of these sets the number of threads - that is, the degree of parallelism - to 4. You can unsubscribe at any time. I have started the upgrade of our SAP production system 4.

As stated in one of the notes for the upgrade I have run the following stastistic updates as preparation for the upgrade last week. During the week that has past many updates were made in the SAP production system. Is it ok to rerun those 3 brconnect commands before phase downtime starts on Friday night to bring the DB stats up-to-date? The Preprocessing step already created some statistics for new tables with special scripts and I assume those will be overwritten when I rerun the brconnect commands….

I simply followed the upgrade guide and when it asked me to run it, I did it at that time only. Thanks for your reply. No Account? Sign up. By signing in, you agree to our Terms of Use and Privacy Policy. Already have an account? As per note See example below:. The "Old number" should correspond to the number delivered in the note The new number should be as close to old number as possible.

From the script:. So, the "Old number" should correspond to the number delivered in the note which is