Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: explain plan changes if using bind vars
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
![]() |
![]() |