Execution plan says statistics are missing but they do exist

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?
ThanksThe stats might be out of date, so you might want to run 'update statistics
with fullscan'.
-oj
<pshroads@.gmail.com> wrote in message
news:1139267489.347659.231960@.g43g2000cwa.googlegroups.com...
>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
>|||Hi thanks for responding.
I have already tried an update stats with full scan. The execution plan
still says that there are statistics missing.|||Hmm...Does it give you the name of the stat? If so, drop and recreate it.
If that still doesn't work, consider rebuilding your clustered index.
-oj
<pshroads@.gmail.com> wrote in message
news:1139331944.099545.38580@.g44g2000cwa.googlegroups.com...
> Hi thanks for responding.
> I have already tried an update stats with full scan. The execution plan
> still says that there are statistics missing.
>