SQL Server Update Statistics with Full Scan

[@aravindsai6371]

Do we have any queries to check how much time will take to complete update statistics

[@Maxwell-237]

The runtime was the same, what was the point of all that?

[@MeskeremMersha-w2i]

If 3 second is the normal metric for execution time how did he say one minute and 37 second is not a big deal ?

[@AllenAchaemenes]

Is full scan the same as 100 percent actual sample rate?

[@iliashterev38]

Thank you for your time and efforts to bring these knowledges to us. Estimation is far better, OK. But why time is even greater? Question from a mid level DB developer.

[@HYBRIS95]

I was wondering if changing the sampling pourcentage might have a positive effect on your case ? Also you did not speak about the table structure (does it have a Primary Key?), couldn't that have an effect on the statistics without having to make a full scan (which can be very time-consuming on very large databases, im speaking of tera-octets) ?

[@nicolashidalgo1888]

Excelente!

[@caglim]

Awesome