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