Improving Basis performance without histograms

Use this tip to advance and improve your adminstration performance.

The Oracle 9i optimizer uses histograms if they are available. To improve performance significantly, do NOT use...

histograms. Our query executions went from 45 seconds to three seconds. In the initSID.sap file, make sure that

stats_method = E

To remove histograms, run:

'analyze table table_name estimate statistics'

on those tables that have histograms.

For DB13 UPDATESTATS, stats_method = E will ensure that NO histograms are generated.

This was last published in July 2005

Dig Deeper on SAP Basis administration and NetWeaver administration

PRO+

Content

Find more PRO+ content and other member only offers, here.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close