January 24, 2008 at 6:19 am
1> When i say Auto create statistics, what are the columns for which statistics are collected? Are these all columns part of the primary key or just the index statistics?
2> What is the difference between index statistics and column statistics?
3> Do i need to explicitly create statistics for columns which are not part of primary key but are used in queries?
4> Who are candidates for column statistics?
5> If i explicitly create statistics on some columns, is updating them my resposibility or its taken care of by auto update statistics?
6> Which system table stores statistics information?
January 24, 2008 at 7:14 am
Please - don't cross post. they all get read....
Answered by gilaMonster over here:
http://www.sqlservercentral.com/Forums/Topic446867-65-1.aspx
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply