Driving_site hint ignored !!!
774653May 23 2010 — edited May 23 2010Hi all,
I got a query which runs in database A , but queries all the tables from database B. Hence we have used driving_site hint , to run the query in database B itself.
There is only 1 input parameter 'from_date' in the query.
If we hard-core the input parameter, the query runs in under 2 mins.
But if we use Bind variable ( : ) to pass the value at run time, the query takes around 30 mins to execute!
Now if we check the explain plan of both the approaches, they differ.
Driving site hint is ignored , when the bind variable is used!! Hence the query takes eternity to complete.
Can anybody knows the work around of this issue? or atlest a root cause of it?
I have to use bind variable in the query..
Edited by: user10303997 on May 23, 2010 6:12 AM
Edited by: user10303997 on May 23, 2010 6:12 AM