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 durchgefuehrt"
Flo
Daniel Castro schrieb:
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
ICQ : 316727989
Jabber: danielti
Linux User: 387864
AOL User: Danielti2005
Sola Scriptura, Sola Gratia, Sola Fide, Solus Christus, Soli Deo Gloria
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
