Hints : DRIVING_SITE

The DRIVING_SITE hint forces query execution to be done at a different site than that
selected by Oracle. This hint can be used with either rule-based or cost-based
optimization. Table is the name or alias for the table at which site the execution should
take place.

SELECT /*+ DRIVING_SITE(DEPT) */ *
FROM EMP,
WHERE EMP.DEPTNO = DEPT.DEPTNO;

If this query is executed without the hint, rows from DEPT will be sent to the local site
and the join will be executed there. With the hint, the rows from EMP will be sent to the
remote site and the query will be executed there, returning the result to the local site.

[@more@]