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

Home -> Community -> Usenet -> c.d.o.tools -> Re: same code, different output

Re: same code, different output

From: Bob Fazio <rfazio_at_home.com.nospam>
Date: 2000/05/07
Message-ID: <WH4R4.175030$Tn4.1321983@news1.rdc2.pa.home.com>#1/1

An analyze may have been run on the table's.

--
Robert Fazio, Oracle DBA
rfazio_at_home.com
remove nospam from reply address
http://24.8.218.197/
"david spaisman" <davedba_at_advanix.net> wrote in message
news:HO2R4.2023$Ts4.213657_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 Sun May 07 2000 - 00:00:00 CDT

Original text of this message

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