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: explain plan changes if using bind vars

Re: explain plan changes if using bind vars

From: William Robertson <william.robertson_at_bigfoot.com>
Date: 6 Aug 2005 10:32:31 -0700
Message-ID: <1123349551.241042.296190@z14g2000cwz.googlegroups.com>


NetComrade wrote:
> On 4 Aug 2005 00:13:44 -0700, "William Robertson"
> <william.robertson_at_bigfoot.com> wrote:
>
>
> >DRIVING_SITE, perhaps?
> >http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96533/hintsref.htm#5699
> >
>
> I want to say it didn't work.. but I only recall that we tried it and
> it didn't work.. perhaps it didn't make the query acceptabally
> efficient.
>
> .......
> We use Oracle 8.1.7.4 and 9.2.0.5 on Solaris 2.7 boxes
> remove NSPAM to email

One thing at a time. Did it influence the optimizer to perform joins on the remote site that it previously did locally? Received on Sat Aug 06 2005 - 12:32:31 CDT

Original text of this message

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