Skip to Content
Former Member
Sep 26, 2008 at 07:53 PM

BW : Run stats for a very long time.



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"


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

Thanks for your input.