Update statistics why/how

[Former Member]

Dear Forum

I am running a light weight OLTP workload with MaxDB and

am hitting my first bottlenecks. It was suggested that I run update statistics. I can't seem to get it working according to the online documentation. I need to run

exec_xpu or xpu. Neither works. The database is ONLINE.

Any idea what I'm doing wrong?

Also - how often should the statistics be updated?

Thanks!

dbmcli -d igen -u DBA,DBA

dbmcli on IGEN>exec_xpu

ERR

-24964,ERR_EXECUTE: error in program execution

65280,xpu

Error during searching of the name of the database: no database name found

[Former Member]

Sorry I did get this working -

sqlcli -d igen -u DBA,DBA

update statistics customer_125

However it made no change in performance!

If anyone has a good paper or pointer to one on high performance tuning for a new-guy that would be appreciated!

/regards

Don C.