Update Statistics, Auto_Update_Statistics - please clarify

I seem to be having trouble posting a reply, so I'm trying this and will edit in a moment...

Hi Smitha.

Basically, what the "If you instruct the database engine not to automatically maintain statisics, you must manually update the statistical information." statement is syaing is that you have told the engine not to auto track/update stats info, so you are responsible for updating them yourself manually, via a method like the one you mention above. As for if it is frequent enough, or best for your application, it always depends.

Well, I can't seem to post the rest of my response...I'll keep trying...

I can't see to write anything else about this...everytime I try putting in a paragragh about the stats stuff, I can't post. I'll still try again in a while, sorry for the delay.

ChadBoyd at 2007-10-8 >

Well, let's try it with the new post...

The upd ate stats statement will reenable auto updating of stats for the given index or table that you specify in the statement, unless you specify the no re compute clause. So, if you want the auto updating of the stats for the given object to continue to NOT be updated even after issuing your upd ate stats command, simply include the no re compute clase in the statement you are running in your job.

Bear with me...I'm trying this in chunks to see if I can get the whole thing posted...seem to be having trouble using certain words or characters...pardon the punctuation, I'm deliberatley doing it to see if I can get it posted...

As for the auto updating stats async option, it basically tells the engine to, well, update stats asyncronously vs. syncronously. Note however, that this option only comes in to play for auto updating of stats, not manual updating. Basically, typically if a query triggers an auto stat updating event without this option set, the query will wait as stats are updated, then the query will be executed. If you set this option, the query will be executed (against the old stats) and the engine will update the stats automatically in the background. As soon as the background operation completes, new query requests will begin to use the new statistics information.

Phew, finally made it in about 35 attempts. HTH

ChadBoyd at 2007-10-8 >