发明申请
US20070038595A1 Query processing in a parallel single cursor model on multi-instance configurations, using hints
有权
使用提示在多实例配置上的并行单光标模型中进行查询处理
- 专利标题: Query processing in a parallel single cursor model on multi-instance configurations, using hints
- 专利标题(中): 使用提示在多实例配置上的并行单光标模型中进行查询处理
-
申请号: US11202453申请日: 2005-08-11
-
公开(公告)号: US20070038595A1公开(公告)日: 2007-02-15
- 发明人: Bhaskar Ghosh , Thierry Cruanes , Benoit Dageville
- 申请人: Bhaskar Ghosh , Thierry Cruanes , Benoit Dageville
- 主分类号: G06F17/30
- IPC分类号: G06F17/30
摘要:
A database statement is processed in a multi-server system, in a manner to increase the possibility that slave server processes on remote nodes will generate execution plans that are equivalent to the corresponding execution plan generated by the query coordinator process. A set of hints is generated based on the same information on which the master plan is based. The set of hints is sent to remote nodes, where respective remote plans are generated based in part on the set of hints. Use of the hints in generation of the remote plan increases the possibility that the remote plan will be equivalent to the master plan and that the slaves on the other database server will be able to join in parallel processing of the database statement.
公开/授权文献
信息查询