UPDATE STATISTICS, good? 
Author Message
 UPDATE STATISTICS, good?

I have several stored procedures that use "update statistics for procedure..."
to update some other procedures that this procedure need to reference.
That works fine in INFORMIX 7.1.1, but crash database in INFORMIX 7.1.3.
So, is UPDATE STATISTICS really important, or I can ignore them?
BTW, is this the INFORMIX bug?

Jack



Wed, 18 Jun 1902 08:00:00 GMT
 UPDATE STATISTICS, good?



Quote:

>I have several stored procedures that use "update statistics for procedure..."
>to update some other procedures that this procedure need to reference.
>That works fine in INFORMIX 7.1.1, but crash database in INFORMIX 7.1.3.
>So, is UPDATE STATISTICS really important, or I can ignore them?
>BTW, is this the INFORMIX bug?

>Jack

  You only need to update statistics when the amount of data in a table
changes but a large amount. Try running it just once a day.

--
David Williams



Wed, 18 Jun 1902 08:00:00 GMT
 UPDATE STATISTICS, good?

Quote:
> Update statistics crashed system

We had a similar problem with 7.13 on DEC Alphas and tracked it
to a known informix bug (flush_sub bug, either 50230 or 44820 bug
number). Informix sent out a patch to fix it.

It only happens when UPDATE STATISTICS is run at the same time as
other Informix processes - therefore try to run it when no-one
else is logged in. If your database is large or records are
added/deleted frequently then it is very important to run it to
maintain the speed of your reports etc.

Paul R.



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Performance Issues with UPDATE STATISTICS WITH FULLSCAN on _WA_Sys auto statistics

2. ANNOUNCE: Another update statistics utility - latest update

3. An update statistics program - updated version for you

4. Big oh statistics for maximum moves of new patented sorting algorithm better than heap sort

5. Big oh statistics for maximum moves of new patented sorting algorithm better than heap sort

6. Big oh statistics for maximum moves of new patented sorting algorithm better than heap sort

7. Big oh statistics for maximum moves of new patented sorting algorithm better than heap sort

8. Big oh statistics for maximum moves of new patented sorting algorithm better than heap sort

9. Waht is better: Insert and update or Select Update else insert

10. Update statistics

11. updating statistics and recompiling stored procedures

12. Update Statistics Error


 
Powered by phpBB® Forum Software