Skip to end of metadata
Go to start of metadata

Use

Number of tables where update statistics is required: <number> (see SYSDBA.SYSUPDSTATWANTED)

<number_of> tables contain > 1.000.000 records but only 20.000 rows will be sampled for statistics

 

Explanation

The database system determines basic statistical information about the size and value distribution of tables and indexes by performing "Update Statistics". If the statistics are outdated or created on the basis of a too small sample value this may lead to wrong optimizer decisions and thus massive performance problems.
Detailed information can be found in the corresponding FAQ note; see below.

 

User Response

 

More Information

Relevant  DB-Analyzer Files
Helpful with ...
  
SAP Note
Helpful with ...
927882 FAQ: SAP MaxDB UPDATE STATISTICS
Expert Sessions (Link to trainings)
Content / Helpful with ...
 Session 16: SAP MaxDB SQL Query Optimization (Part 1) 
 Session 16: SAP MaxDB SQL Query Optimization (Part 2) 
Documentation (links)
Helpful with ...
  

                            

  • No labels