statistics

Question

Hi all,

what is the statistics in ms sql server and what is the use of statistics......?

thanks

naga

Answer 1

Statistics in SQL Server
https://www.simple-talk.com/sql/learn-sql-server/statistics-in-sql-server/

---

Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

Answer 2

SQL Server MCM Readiness Video: Statistics

---

John Sansom | SQL Server DBA Blog | @SQLBrit on Twitter | SQLBrit Community Forum - A place to share all the "other stuff" there is to being a Data Professional

Answer 3

Hi naga

Statistics : it is defined as detail about table like no.of records , available indexes , page density. If statistics are available SQL Server tries to use statistics to “react intelligently” in its query optimization. Knowing number of records, density of pages, histogram, or available indexes help the SQL Server optimizer “guess” more accurately how it can best retrieve data.

What is Statistic in sql server

What is Statistic in Sql Server Part - 2

Yes ! Auto update stats causing Performance issues??

Technical Article on Statistics

SQL Server 2008 Statistics

Understanding SQL Server Statistics

---

Thanks
Saurabh Sinha
http://saurabhsinhainblogs.blogspot.in/
Please click the Mark as answer button and vote as helpful if this reply solves your problem

Answer 4

Hi sinha,

what is the histogram and page density ..?

Answer 5

Hi naga,

Try this link , i have documented few basic informations , when i started to learn about statistics

http://sathyadb.blogspot.in/2012/08/sql-server-statistics.html?showComment=1357542567862

---

Thanks & Regards, sathya

Answer 6

Histogram is a statistical report that shows you the frequency of values within steps or ranges of values that fall between a certain minimum and maximum.

Statistic in Sql Server

Page density : How much page is full, if the page density is low then you will likely to store less data in the pages and wasting disk space as well as valuable memory

---

Thanks
Saurabh Sinha http://saurabhsinhainblogs.blogspot.in/
Please click the Mark as answer button and vote as helpful if this reply solves your problem