• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 524
  • Last Modified:

IO Statistics Vs Table Statistics - SQL Server 2005

Hi,

Please let me know what is the difference between table Statistics & IO Statistics.

1. As per my knowledge Table Statistics are updated automatically (If Database option is set to True). But what about IO Statistics?

2. When we rebuild index table Statistics are also updated?
3. If IO Statistics and  Table Statistics are different, then how to update  IO Statistics?

regards,
Sagar

0
srinivas_ganamur
Asked:
srinivas_ganamur
  • 2
  • 2
1 Solution
 
lofCommented:
Hi,

In simple terms:

Table Statistics are information about the table consisting of things like (number of rows and pages occupied by data, selectivity of columns, information about indexes and such) and it is used by optimiser to boot the query performance automatically.

IO Statistics are information about single query and how it get's the data. You may use it to improve the query design manually.

1. IO Statistics are generated each time you run a query if the option STATISTICS IO is set to ON.
2. As far as I know (but here I might be wrong) Statistics are not updated when you rebuild an index.
3. You don't need to update them as they are not stored. See point 1.
0
 
srinivas_ganamurAuthor Commented:
Hi Experts,

any comments on Point 2 and 3

2. As far as I know (but here I might be wrong) Statistics are not updated when you rebuild an index.
3. You don't need to update them as they are not stored. See point 1.
0
 
lofCommented:
3 is for sure. IO Statistics does not need bo be updates so there is no way to do it.

2 is something I am not sure. Nowhere on MS documentation I can see information about statistics updates and index rebuilding to be related in any way so I assume they are not. That means rebuilding index does include updating statistics.
0
 
srinivas_ganamurAuthor Commented:
--
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now