Update Statistics - Not Implemented Yet

I am trying to run update statistics on a table and get the following error. Does anyone have any ideas what could be causing this? My queries are running very slowly and as I understand it this may be a way to help. Error --- Auto Commit: On, SQL Mode: Internal

Re: Update Statistics Issue

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

Update Statistics Issue

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

Update statistics

Hi, Is there a way to run an update statistics statement on a table without blocking inserts to the table ? I've tried using lowest isolation level via sql (though didn't think it would help) Also using the sql_updatestat command, however each stop inserts happening on the table i

RE: update statistics ???

> After creating a lot of tables and loading data from another server i > want to do an update statistics. > > I tried dbmcli -d xxx -u dba,xyz -n xxxx > > update statistics * > > err: unkown command update > > Did i miss something ??? have you checked this

update statistics ???

Hello Everybody ! After creating a lot of tables and loading data from another server i want to do an update statistics. I tried dbmcli -d xxx -u dba,xyz -n > update statistics * err: unkown command update Did i miss something ??? Any help welcomed Alb

AW: Incremental Backups and Update Statistics

Hello Uwe, > -Ursprungliche Nachricht- > Von: Hahn, Uwe [mailto:[EMAIL PROTECTED] > Gesendet: Mittwoch, 12. Januar 2005 12:09 > An: Florian Schmitz; maxdb@lists.mysql.com > Betreff: RE: Incremental Backups and Update Statistics > > > Hi Florian, > > what rele

RE: Incremental Backups and Update Statistics

, January 12, 2005 10:07 AM >To: maxdb@lists.mysql.com >Subject: Incremental Backups and Update Statistics > > >Hello folks, > >our Installation suffers from gigantic incremental databackups >since a few >weeks. >(11GB for a Complete Backup, 7-9GB for an Incremental

AW: Incremental Backups and Update Statistics

> increased. > > So my question is : > Does a complete Update-Statistics change the data in a way, so a > incremental > databackup might consider saving huges amounts of data? Goodness, no! UPDATE STATISTICS does not change any data of the user, does not change the size of the

Incremental Backups and Update Statistics

Hello folks, our Installation suffers from gigantic incremental databackups since a few weeks. (11GB for a Complete Backup, 7-9GB for an Incremental) We've installed an "Update-Statistic"-Script about the same time the size increased. So my question is : Does a complete Update-St

update statistics problem

Hi, we still have problems getting our udate of the statistics we have Sapdb 7.4.3.32/7.4.3.31 running on Linux Redhat and Suse. In our backup procedure we have util_connect util_execute check data except index sql_updatestat backup_start pipe data The proposed alternative was to use UPDATE

RE: Update statistics

Ajit Aranha wrote: > > Hi, > Where in the documentation can I find info on update statistics (for > 7.3 / 7.4). http://www.sapdb.org/7.4/htmhelp/3b/86f067458411d3a98200a0c9449261/frameset.htm > > Is there a guide on using the optimizer in the dbmgui and what doing &g

Update statistics

Hi, Where in the documentation can I find info on update statistics (for 7.3 / 7.4). Is there a guide on using the optimizer in the dbmgui and what doing this actually does ‘under the hood’ ?? Regards, Ajit

RE: MaxDB UPDATE STATISTICS on clones / replication partners

[EMAIL PROTECTED] wrote: > As I have mentioned on the list on the past... UPDATE > STATISTICS requires lots of slow disk I/O and it locks the > tables. Some of our tables > are large and the lock can last for long periods (30 minutes > or longer for a single table).

MaxDB UPDATE STATISTICS on clones / replication partners

Hi, As I have mentioned on the list on the past... UPDATE STATISTICS requires lots of slow disk I/O and it locks the tables. Some of our tables are large and the lock can last for long periods (30 minutes or longer for a single table). Yes, this is on professional 15,000 RPM SCSI hard

Re: Block connections while update statistics

X_SERVER? Georg Timo Denis huet geschriwen: Hi, is there any way to block connection for several clients while SAPDB is running update statistics? In detail we want to block about 10 hosts from the server when the update statistics is running, and also others have to access the system, too

Block connections while update statistics

Hi, is there any way to block connection for several clients while SAPDB is running update statistics? In detail we want to block about 10 hosts from the server when the update statistics is running, and also others have to access the system, too! Regards, Timo -- Timo Denis, [EMAIL PROTECTED