Re: Warnings
- From: "Joh" <joh@xxxxxxxxxxxx>
- Date: Tue, 17 May 2005 12:41:20 -0400
Thanks
"Cristian Lefter" <nospam_CristianLefter@xxxxxxxxxxx> wrote in message
news:OXpsTVvWFHA.2976@xxxxxxxxxxxxxxxxxxxxxxx
> [quote]
> Sometimes you might see "NO STATS:()" in this column. That means that the
> optimizer is trying to make some kind of judgment based on the statistics,
> and you also get the columns along with the no stats predicate. So what
that
> means is that optimizer is trying to make some decisions based on the
> statistics of those columns, and the statistics are not there. So as it
is,
> the optimizer might not get an efficient plan; you might see an
inefficient
> plan.
>
> The statistics for columns are generally created automatically by SQL
Server
> optimizer, but that is a configurable option, and if that is turned off
then
> SQL might not be able to create stats for those columns. So if you see
> anything like no stats in the Warnings column, that means you need to be
> cautious, and then you go back to those columns and see if you can create
an
> index or turn on autostats so that SQL cannot automatically create stats
for
> those columns.
> [/quote]
>
> Please refer to "Microsoft SQL Server 2000: Reading Execution Plans in SQL
> Server 2000"
>
http://support.microsoft.com/default.aspx?scid=%2Fservicedesks%2Fwebcasts%2F
en%2Ftranscripts%2Fwct032703.asp
> for additional information.
>
> Cristian Lefter, SQL Server MVP
>
> "Joh" <joh@xxxxxxxxxxxx> wrote in message
> news:uY0eGNuWFHA.132@xxxxxxxxxxxxxxxxxxxxxxx
> >I have find out one long running query through SQL Profiler and I copy
that
> > stored procedure and run in to query analyzer with the following
settings.
> >
> >
> > set statistics profile on
> > set statistics io on
> > set statistics time on
> >
> > In the output of warning column I found Null with all of them but with
> > four
> > of them it gave the following warnings..
> >
> >
> > NO STATS:([LInfo].[CTID])
> >
> > NO STATS:([OSc].[SCID], [OSc].[RCID])
> >
> > NO STATS:([LInfo].[CTID])
> >
> > NO STATS:([Tfer].[RCID], [Tfer].[SCID])
> >
> > What this warnings indicate ? can any one give me some idea what I have
to
> > do ?
> >
> > Thanks
> >
> >
> >
>
>
.
- References:
- Warnings
- From: Joh
- Re: Warnings
- From: Cristian Lefter
- Warnings
- Prev by Date: Re: Remove from Cache
- Next by Date: Backup into another machine.
- Previous by thread: Re: Warnings
- Next by thread: Remove from Cache
- Index(es):
Relevant Pages
|
