ITPub博客

首页 > 数字化转型 > ERP > Hints : DRIVING_SITE

Hints : DRIVING_SITE

原创 ERP 作者:tsinglee 时间:2007-12-05 13:31:45 0 删除 编辑

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, DEPT@RSITE
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@]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10599713/viewspace-988771/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    740
  • 访问量
    1897662