sql server misc: Execution plan says statistics are missing but they do exist -- sql server misc

Execution plan says statistics are missing but they do exist

pshroads NO[at]SPAM gmail.com
2/6/2006 3:11:29 PM

sql server misc:

I am looking at the graphical estimated execution plan in Query
Analyzer for a query. One of the steps in the query is in red and
indicates "Warning: Statistics missing for this table..." for a column.

However I have used both sp_helpstats and DBCC SHOW_STATISTICS to
verify that statistics do in fact exist for this column. Is this just a
Query Analyzer bug or is this something to worry about where the
optimizer is not seeing statistics that do in fact exist?

Thanks

Re: Execution plan says statistics are missing but they do exist

oj
2/6/2006 4:51:56 PM

The stats might be out of date, so you might want to run 'update statistics
with fullscan'.

--
-oj

[quoted text, click to view]