1.DRIVING_SITE
The DRIVING_SITE hint instructs the optimizer to execute the query at a different site than that selected by the database. This hint is useful if you are using distributed query optimization.
SELECT /*+ DRIVING_SITE(departments) */ *
FROM employees, departments@rsite
WHERE employees.department_id = departments.department_id;
In the above example, optimizer will use the tables of "rsite" and query will be executed at "rsite" database.
阅读(2457) | 评论(0) | 转发(0) |