driving_site and local function call
From: steph <stephan0h_at_yahoo.de>
Date: Thu, 19 Jun 2008 09:57:29 -0700 (PDT)
Message-ID: <544ed7dd-b119-40a3-8f91-f6977a71e367@a9g2000prl.googlegroups.com>
from table1_at_remotedb
inner join table2_at_remotedb on <join condition> ...
Date: Thu, 19 Jun 2008 09:57:29 -0700 (PDT)
Message-ID: <544ed7dd-b119-40a3-8f91-f6977a71e367@a9g2000prl.googlegroups.com>
oracle 10G R2:
I've got this query accessing a lot of remote data via database link. Therefore hint DRIVING_SITE is used to make the query happen on the remote server. Now I've done a change, I call a local package function, which makes the hint being ignored.
The query looks something like this
select /*+DRIVING_SITE(table1) */
<col1>, ... , local_package.myfunc()
from table1_at_remotedb
inner join table2_at_remotedb on <join condition> ...
When I comment the function call everything works as excpected, but when the function call is uncommented the query is happening locally. Is there any reason why the DRIVING_SITE-hint get's ignored the moment i call the local function? Bug or feature?
Thanks,
Stephan
Received on Thu Jun 19 2008 - 11:57:29 CDT