RE: update statistics while inserting data

Develop shell script to include the following in the SQL commands. Set isolation to dirty read; Set lock mode to wait; Update statistics statements; Run it every couple of hours once in the cron. Ravi Yarlagadda -----Original Message----- From: Koen LEFEVE.... [mailto:Koen.Lefever@dhl.com] Sent: Tuesday, April 20, 2004 9:45 AM To: ids@iiug.org Subject: update statistics while inserting data [2852] Hi, We have a database where data is being inserted continiously (at least once every 15 minutes) and which has to be up all of the time (24/24). The tables are fragmented per day. We now stop the inserts during the weekend to update the statistics, but by the end of the week performance degrades drastically - so we would like to run an update stats during the week, but we cannot stop the inserts to do this. Is it possible to update the stats while quite a lot of data is being inserted? Did anybody face & solve such problem before or has any advice? We are using IDS9.40 on HP/UX and Linux. Thanks in advance, Koen.