cancelling update statistics command

20/05/2008, 23h23

If I run an update statistics and then cancel it before finishing, does it
have any kind of effect on statistics? Or is the end result the same as not
having run anything in the first place?

Thanks!

21/05/2008, 09h01

Sam
Run DBCC SHOW_STATISTICS to ensure what tables are updated.

"Sam" <Steve.sam@hotmail.com> wrote in message
news:eAze5%23ruIHA.5832@TK2MSFTNGP02.phx.gbl...
> If I run an update statistics and then cancel it before finishing, does it
> have any kind of effect on statistics? Or is the end result the same as
> not having run anything in the first place?
>
> Thanks!
>

20/05/2008, 23h23	#1
Sam Messages: n/a Hébergeur:	cancelling update statistics command If I run an update statistics and then cancel it before finishing, does it have any kind of effect on statistics? Or is the end result the same as not having run anything in the first place? Thanks!

21/05/2008, 09h01	#2
Uri Dimant Messages: n/a Hébergeur:	Re: cancelling update statistics command Sam Run DBCC SHOW_STATISTICS to ensure what tables are updated. "Sam" <Steve.sam@hotmail.com> wrote in message news:eAze5%23ruIHA.5832@TK2MSFTNGP02.phx.gbl... > If I run an update statistics and then cancel it before finishing, does it > have any kind of effect on statistics? Or is the end result the same as > not having run anything in the first place? > > Thanks! >

Outils de la discussion
Afficher une version imprimable Envoyer un lien vers cette page par email