From: Florian Schmitz (fschmitzacardo.com)
Date: Tue Mar 07 2006 - 10:08:10 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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: danieltigmail.com
> 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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]