Re: Update statistics for large databases

You should change the DBUPSPACE to the following: DBUPSPACE=0:50:1 0 Unlimited disk space usage for sorts 50 50 MB of memory for sorting in memory. This is the maximum that can be giving to memory sorting without PDQ. 1 Do not use index paths and print additional info in sqexplain.out I am guessing the problem is with using index paths. If an index path is choosen for a large index this can really slow down update statistics. Also make sure that when you run update statistics with PDQPRIORITY that you only update tables and not procedures. John Miller hatricom wrote: > Hi, > > how can I obtain a short time for my update statistics on a large > databases. > It's run on a machine with 8 processors, 32 Gb Ram, RHEL4 and IDS 10 > FC4. > > My script for update statistics begins with update statistics medium on > database and continue with update statistics low and high for the > tables which are most used. > > I use PDQPRIORITY 80 for tables and 1 for procedures. > DBUPSPACE=25000:1000 > The script finish in about 5 hours, the database is 70 Gb large. >