X hits on this document

122 views

0 shares

0 downloads

0 comments

24 / 48

Microsoft’s SAP ERP (R/3) System (cont)

Automatic Update Statistics might not update aggressively enough

Scenario1: Tables with less than 500 rows

Usually not a problem when table is just used for a lookup or scan

Problem a bit more severe when several of those tables are used to join with a larger table

Could result in performance problems due to the join order chosen based on ancient statistics

Solution: Schedule Update Statistics for such small tables from time to time

DBA-416M• ISV configurations & implementations – Lessons Learned

Document info
Document views122
Page views122
Page last viewedSat Dec 10 11:04:48 UTC 2016
Pages48
Paragraphs862
Words4327

Comments