Re: Update Statistics ? - Abhay Mannur. ( amannur@spf.fairchildsemi.com )

In article <6c9tva$nce$1@news.xmission.com>, Abhay Mannur <amannur@spf.f airchildsemi.com> writes > >We were running update statistics high for whole database and we wanted >to reduce the execution time for that. So we planned to find the most >volatile tables and update staistics high for those tables. When I ran >that script, it took more time than before. >Can anybody give me the reason for this or solution for my problem ? > >Abhay. >amannur@spf.fairchildsemi.com Not really without a details description of the disk layout you use, hardware configuration, Oniine configuration, scripts used and timings!!! -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care