Re: Question on the order of execution of UPDATE STATISTICS

Check out the FAQ at www.iiug.org, it gives details on update stats and the order of doing things. Of course you could always look the manaul as far as I remember it is detailed :-) I've got a shell script around somewhere that will generate the stats for you - email if you want a copy -- Paul Watson WF Software Ltd. Tel: +44 1436 674729 Fax: +44 1436 678693 Email: paulw@wfsoftware.co.uk sujata_soman_at_omm-la2-infotech-001@internet.omm.com wrote in article <64b2g4$mg@cssun.mathcs.emory.edu>... > > 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 >