Skip to Content
Former Member
Jun 28, 2007 at 05:48 AM

REgarding Update Statistics



We are running Update Optimizer Stats using DB13 every morning with the following options : brconnect –u / -c –f stats –t all (ofcourse this comes by default) .The stats log are showing as completed but still if we go to db20 for a specific table say PPOIX it is showing as follows:


Statistics are current (|Deviation| < 50 %)

New Method E

New Sample Size P3

Old Method E Date 17.05.2006

Old Sample Size P1 Time 11:56:24

Old Value 25.523.937 Deviation Old -> New 22 %

New Value 29.996.089 Deviation New -> Old 15- %

You can see the Date analyzed is showing still way back as 17.05.06 and the deviation percentage is 20% which is more than the threshold limit of 20% kept in file. Is there anything wrong in brconnect syntax specified or is there any other reason for not updating the stats ?

Also if i go to DB20 and force the stats with CI option (check and update stats for the table along with indexes) it is doing the update and also showing in db20 next time i see or in db02 detailed analysis but next time if you update again say after couple of days,it still takes hugh amount of time to update as if like never updated earlier.

Any idea of why is it happening like this ?