Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

BW : Run stats for a very long time.

Hi,

The UpdateStats job takes up to 48h to complete the run. It appears that the problem happened for a while (at least 3 months). The command used is : brconnect -u / -jid STATS20080413100000 -c -f stats -t ALL -f monit I remark that the sample size of method Estimate is setting at 100, and almost of tables are partitionned. My questions are : 1) Where is the sample size set in SAP for partitionned tables ? 2) How can I modify it ? Here is an extraction of "Tables with longest duration of collecting statistics for owner R3"

Table--


Duration-Rows/oldRows/newMeth./Samp. -
[m:s] /BIC/FZPM_CEVT--288:12(106219000)-106353900EH/P100 /BIC/FZPM_C04-----285:47-(57471500)57513900---EH/P100 /BIC/FZPMCINEVT-219:34-(107708800)-107947000 EH/P100

Thanks for your input.

Not what you were looking for? View more on this topic or Ask a question