Update statistics suggestions --Urgent
Hi
I have a database with around 80 to 90 tables , and cron job is
running for
UPDATE STATS "update statistics high " runs every night on
database and on sysutils , we do have lot of inserts going to
database for few tables everyday . The biggest table has 500000 rows.
most of the tables ara static .
Is this update stats is fine or do i have to run individual stats for
each table. And also do i have to run update stats for procedures ,
sysmaster and sysutils also with the database.
At the moment if i run the following query
Select distinct tabname,b.constructed,b.mode
from systables a,sysdistrib b
where a.tabid = b.tabid
order by 1It shows the todays date for all the tables expect few tables it shows
3 months old date any clues on this? this is on the existing server .
I am setting up a new server for production ,i did dbimport without
the update stats , application log shows " Optimizer can not find
etc."
Can i just do the dbimport and run update stats in the night ? Why
does it give an error when u import the database without stats?
I did dbimport with same UPDATE STATS commands in the export file
again ,application works fine without any errors.
I have informix version 9.21.UC1 on Solaris . Any suggestions for the
new serever about setting up UPDATE STATS would be a great help for
me .
Regards
Kalpana
On Wed, 20 Aug 2003 00:53:43 -0400, KalpanaPai wrote:
Running HIGH on the whole database is unneccessary. It takes longer than
it needs to. Read the "Performance Guide" manual and follow the
recommendations there or get one of the excellent tasks and scripts
available from the IIUG Software Repository that will implement the
recommended protocol for you. The best of these is my dostats utility
which is contained, with several other useful utilities, in the package
utils2_ak.
Art S. Kagel
> Hi
>
> I have a database with around 80 to 90 tables , and cron job is running
> for
> UPDATE STATS "update statistics high " runs every night on database
> and on sysutils , we do have lot of inserts going to database for few
> tables everyday . The biggest table has 500000 rows. most of the tables
> ara static .
>
>
> Is this update stats is fine or do i have to run individual stats for
> each table. And also do i have to run update stats for procedures ,
> sysmaster and sysutils also with the database.
>
> At the moment if i run the following query Select distinct
> tabname,b.constructed,b.mode from systables a,sysdistrib b where
> a.tabid = b.tabid
> order by 1
> It shows the todays date for all the tables expect few tables it shows 3
> months old date any clues on this? this is on the existing server .
>
> I am setting up a new server for production ,i did dbimport without
> the update stats , application log shows " Optimizer can not find etc."
> Can i just do the dbimport and run update stats in the night ? Why does
> it give an error when u import the database without stats? I did
> dbimport with same UPDATE STATS commands in the export file again
> ,application works fine without any errors.
>
> I have informix version 9.21.UC1 on Solaris . Any suggestions for the
> new serever about setting up UPDATE STATS would be a great help for me
> .
>
>
> Regards
> Kalpana