16 reputation
2
bio website
location
age
visits member for 2 years, 3 months
seen Mar 14 at 20:48

Nov
13
awarded  Supporter
Jul
6
comment How can I find out which statistics are evaluated by the optimizer?
Yes, those are the links I found yesterday by following the link in Aaron's answer.
Jul
5
comment How can I find out which statistics are evaluated by the optimizer?
Btw I'm a heavy user of the SQL Sentry Plan Explorer. Thank you for the freebie.
Jul
5
comment How can I find out which statistics are evaluated by the optimizer?
The link you provided has a link to IMO a better post on how to use traceflags to see the statistics being used. Thank you.
Jul
5
comment How can I find out which statistics are evaluated by the optimizer?
I'll give an example of the kind of thing we've experienced. In a production system with an ad-hoc statistics entity, a certain query ran quickly and successfully. The execution plan indicates it performed a SEEK on index X. When we dropped the statistics, the same query failed. The execution plan changed dramtically; it now performs a SCAN. As it turns out that the join logic in the query is joining int to varchar, and doing implicit conversion on the varchar. We now recognize this as a risk, and we don't want to make more changes without full understanding.
Jul
5
comment How can I find out which statistics are evaluated by the optimizer?
I should mention that we have disabled the AUTOCREATE STATISTICS option in our production environments.
Jul
5
awarded  Student
Jul
5
asked How can I find out which statistics are evaluated by the optimizer?