X hits on this document

144 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 views144
Page views144
Page last viewedThu Jan 19 04:59:32 UTC 2017
Pages48
Paragraphs862
Words4327

Comments