SAP Knowledge Base Article - Preview

3597108 - How to-Oracle -Verification steps to confirm if stats need to be ran for your tenant environment

Symptom

Running statistics in Oracle is crucial for maintaining optimal database performance and efficiency. These statistics provide the query optimizer with the necessary information to make informed decisions about execution plans, ultimately leading to faster query execution and reduced resource consumption. 

Here are common reasons for running stats:

  • Cost-Based Optimization
  • Execution Plan Accuracy
  • Maintaining Performance
  • Identifying Performance Bottlenecks
  • System Statistics


Read more...

Environment

SPM Commissions Incentive Management

Keywords

SPM Commissions Incentive Management, Commissions, Oracle, Pipeline, Stats , KBA , CEC-SAL-COM , SuccessFactors Incentive Management , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.