Problem solveGet help with specific problems with your technologies, process and projects.

Using the DRIVING_SITE hint

Oracle expert Brian Peasland explains how the DRIVING_SITE hint can help an optimizer to run a remote query on either the local or the remote system.

Share this item with your network:

Published: 28 Jan 2008

When a join operation comprises elements bound by a dblink (typically "select ... from a,b@dblink1,c@dblink2 where .."), can one oblige the instances concerned to carry out the algebraic operations "projection" and "selection" on their side (not to bring back all on the client side)? Is it possible to use (locally) the distant tables statistics? Also, are there differences in Oracle versions (9.2, 10 and 11)?

You can influence the optimizer to run the remote query on either the local or the remote system with the DRIVING_SITE hint. See the white paper titled "Tuning Distbributed Queried and the DRIVING_SITE Hint" on my web site,
Peasland Oracle Consulting. This paper will show you how to use this hint.

Start the conversation

0 comments

Register

I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.

Please check the box if you want to proceed.

I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.