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"
Thanks for your input.