Re: Question on the order of execution of UPDATE STATISTICS

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 ================================================================