Does update statistics on a table, updates index statistics?

Question

Does update statistics on a table, updates index statistics?

Anamika

SSCertifiable

Points: 6202
More actions
December 5, 2013 at 10:42 pm

#395951

Hi,
Does update statistics on a table, updates index statistics?
Thanks,
Regards,
Ami

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Update statistics on a table updates ALL statistics on that table, index and column alike.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Anamika SSCertifiable Points: 6202 More actions · Answer 2

Thanks,

Is there any blogs / articles to know more about it?

Thanks,

Regards,

Ami

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

There are tonnes of blog posts and articles on statistics available. Spend some time with your favourite search engine and you'll find lots.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Anamika SSCertifiable Points: 6202 More actions · Answer 4

🙂 Thanks for the info...

I was expecting you'll suggest some best ones....

Thanks,

Regards,

Ami

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

You want me to go to google, search for statistics, then link some of the articles that google finds?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Anamika SSCertifiable Points: 6202 More actions · Answer 6

surely NO. 🙂

if you've written or read and felt something is more valuable.... thought of getting it...

Thanks a lot for your reply. I'll google it...

Thanks,

Regards,

Viji