Re: Update statistics suggestions --Urgent

I would suggest that you also run "update statistics low". If you run update statistics on a per table basis, you will be able to execute multiple update stats statements in parallel which will shorten your runtime. Of course there is no need to worry about this if you have plenty of time available for the task. Mark ----- Original Message ----- From: "KalpanaPai" <kalpanapai@hotmail.com> To: <informix-list@iiug.org> Sent: Wednesday, August 20, 2003 00:53 Subject: 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 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 sending to informix-list