Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: same sql code, different explain?

Re: same sql code, different explain?

From: spencer <spencerp_at_swbell.net>
Date: 2000/05/08
Message-ID: <2oJR4.33$fH.1884@news.swbell.net>#1/1

if you "compute" statistics weekly, is there a reason that you need to overwrite these with "estimated" statistics ? just wondering why you would need to do that...

"david spaisman" <davedba_at_advanix.net> wrote in message news:hYlR4.1250$Q7.97135_at_news-east.usenetserver.com...
> Victor:
>
> I run estimate statistics nightly and compute statistics on
 Saturday night.
>
> DAvid Spaisman
> Victor Tsien wrote in message <0z4R4.27$w03.5872_at_elnws01>...
> >Did you run analysis in between or every night?
> >Victor
> >
> >"david spaisman" <davedba_at_advanix.net> wrote in message
> >news:7O2R4.2022$Ts4.212209_at_news-east.usenetserver.com...
> >> Hello:
> >>
> >> One of the develepors fr our application said he ran
 explain for sqlcode
> >> and got different explain output now than he did two weeks
 ago in
> >> production.
> >>
> >> As far as I know, there have been no database chnages, no
 init.ora
 chanegs
> >> and the time span is only two wweks before the first time
 the sqlcode was
> >> run and now. From the counts of certain tables that I
 mantian, I know
 that
> >> there has nor been significant data added. I will check the
 code and the
 two
> >> sets of explain output but I have ben wondering......
> >>
> >> He insists it is the exact same code -- I was leaving
 yesterday and did
 not
> >> have time to check it nor to see the explain output .
> >>
> >> So if it is the exact same code, what would account for
 different explain
> >> output?
> >>
> >> Does any one have any ideas?
> >>
> >> Thanks.
> >>
> >> DAvid Spaisman
> >>
> >>
> >>
> >
> >
>
>
>
Received on Mon May 08 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US