I have a table with a field that has a very large variance on a particular field that is often searched. The number of records associated with any value in the field highly differs.
My estimated number of rows are always off, before refreshing statistics it's highly overestimated after refreshing it's highly underestimated. What can I do to improve it?
I update the statistics with full scan. The code is usually called from within a procedure but now I tested it outside.