http://sqlblog.com/blogs/kalen_delaney/archive/tags/indexes/statistics/default.aspxTags: indexes, statisticsenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/kalen_delaney/archive/2008/02/04/statistics-vs-indexes.aspxMon, 04 Feb 2008 19:44:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:4882Kalen Delaney7http://sqlblog.com/blogs/kalen_delaney/comments/4882.aspxhttp://sqlblog.com/blogs/kalen_delaney/commentrss.aspx?PostID=4882<P>&nbsp;</P> <P><U>What is the difference between statistics and indexes? Do auto created statistics indicate that you should build an index?</U></P> <P>I will be posting answers to some of the interesting questions I get from my students and my readers (these are not two disjoint sets, of course) on the new SQLCommunity site.</P> <P>Check out this the answer to this question at:</P> <P><A title=http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx href="http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx">http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx</A></P> <P>The article has some geeky stuff in it too. For example, it explains how to interpret the strangely named statistics, such as _WA_Sys_00000010_2EDAF651. </P> <P>&nbsp;</P> <P>Have fun!</P> <P><FONT color=#ff00ff>~Kalen</FONT></P><img src="http://sqlblog.com/aggbug.aspx?PostID=4882" width="1" height="1">indexesstatistics