首页>
外国专利>
PARALLEL PREPARATION OF A QUERY EXECUTION PLAN IN A MASSIVELY PARALLEL PROCESSING ENVIRONMENT BASED ON GLOBAL AND LOW-LEVEL STATISTICS
PARALLEL PREPARATION OF A QUERY EXECUTION PLAN IN A MASSIVELY PARALLEL PROCESSING ENVIRONMENT BASED ON GLOBAL AND LOW-LEVEL STATISTICS
展开▼
机译:基于全局和低级别统计信息的大规模并行处理环境中查询执行计划的并行准备
展开▼
页面导航
摘要
著录项
相似文献
摘要
In an approach to preparing a query execution plan, a host node receives a query implicating one or more data tables. The host node broadcasts one or more implicated data tables to one or more processing nodes. The host node receives a set of node-specific query execution plans and execution cost estimates associated with each of the node-specific query execution plans, which have been prepared in parallel based on global statistics and node-specific low level statistics. The host node selects an optimal query execution plan based on minimized execution cost.
展开▼