Via update statistics. A simple script:
#!/bin/sh
# UPDATE DATABASE STATISTICS
SID=PROD
export PATH=/opt/sdb/programs/bin:$PATH
echo "updating database statistics..."
_o=`cat <<EOF | dbmcli -d $SID -u dba,dbapassword
sql_connect dba,dba
sql_execute UPDATE STATISTICS *
EOF`
_test=`echo $_o | grep ERR`
if [ "$_test" != "" ]; then
echo "update statistics failed: $_o" 1>&2
exit 1
else
echo "OK."
fi
exit 0
--
Dinamica - RADical J2EE framework
open source, easy and powerful
http://www.martincordova.com
On 12/27/05, Manuel Reiter <[EMAIL PROTECTED]> wrote:
> Hi, our SAPDB / MAXDB slowed down time by time; As we work a lot with
> indices, is there a command to update the indices or ist this done via
> update statistics ?
>
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
