Hello Daniel,
we run this shell-script once a week. our instance has about 20% of its data changed aweek and a
weekly growth of about 2%.
#!/bin/bash
/usr/sapdb/indep_prog/bin/dbmcli -d INSTANCE_NAME -u , "sql_updatestat
* ESTIM
ATE SAMPLE 100 PERCENT"
echo "update_stat_100 durchgefu
Hi,
How often do I have to use Update Statistics Statement?
Do you usually schedule it to run at night, once a week?
How can I schedule it using cron? What is the correct syntax?
best regards,
--
Daniel Castro
Website: http://danielti.no-ip.info:2139
MSN: [EMAIL PROTECTED]
Skype: danielti2005
I
