>I have some tables which contain some entries in the Statistics section where one of them includes two entries that are pointing to two characters fields. Those two fields are not part of any SQL conditions but only in the list of fields being extracted from the SQL. Why is SQL Server adding them in there in regards to this optimization?


Hi Michel,

Why it doesn't answer your question, you may find following articles helpful:

http://www.microsoft.com/technet/prodtechnol/sql/2005/qrystats.mspx

http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/id/149/language/en-US/Default.aspx (free registraion required)

--sb--