sujata_soman_at_omm-la2-infotech-001@internet.omm.com wrote:
>
> hi all,
> Does it matter what order we run the UPDATE STATISTICS command ? That is, if
> we are running update statistics low on the table, and high on all columns
> heading an index, which should precede what ?? Does it matter if they are done
> concurrently ?? Speaking of which, does anybody know if there are any problems
> if the update statistics job for the whole database is split into 7-8 jobs and
> run parallelly? What are the considerations, if any ??
>
> Thanks
>
> Sujata
>
> ********************************************************************************
> ******************************
> * Sujata Soman
> *
> * E-Mail: ssoman@omm.com
> *
> * Database Administrator ( Informix )
> *
> * O'Melveny & Myers, Los Angeles
> *
> ********************************************************************************
> ******************************
READ THE RELEASE NOTES
*-)
There's also a couple of tools at inxutil.com for just this purpose. Richard
Stanford wrote a 4GL program that does just what you need, which is at the
site.
Tim
--
Tim Schaefer \\\\|//
tschaefe@mindspring.com 6 6
-------------------------oOOo---( )---o00o----------------------
http://www.inxutil.com - My Ezine
http://www.informix.com - Informix Software Inc.
http://www.iiug.org - International Informix User Group/FAQ
news://comp.databases.informix - Newsgroup for Informix Users
================================================================