I have a question regarding db link. I have a query that uses a database link, i speed it up by adding the DRIVING_SITE hint
and it worked when executed from sql*plus or pl/sql developer. It returns results in 3 seconds or even less. However, when
i put this query back into the APEX application, specifically into an interactive report page -- it runs for 3 mins! I'm wondering
if you have some inputs on how to resolve, analyze this issue.
Driving site is mainly useful in certain scenarios, such as joining small local table to large, aggregated remote table.
Here is a simple discussion
IR may modifed the query too much and disrupt the hint? Might need to look deeper.