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"
/BIC/FZPM_C04---- -285:47 -(57471500)57513900---EH/P100
/BIC/FZPMCINEVT -219:34 -(107708800)-107947000 EH/P100
Thanks for your input.