In relation to this question: How can I help the optimizer estimating better?
No histogram is returned by the tools for varchar columns. Instead one shall use the Estimate function to check for the selectivity the optimizer is anticipating for a certain value.
Therefore I am wondering if Create Statistics or Drop Statistics will have any effect for varchar columns?
asked 26 Jul '11, 03:22
The reason that a histogram is not returned is that the frequent-value statistics are hashed, and their internal representation isn't convertible into a useful form that would make sense to an application developer.
answered 26 Jul '11, 12:02