并行查询优化器的目标是缩减庞大的计划搜索空间,获得优化的查询规划。
The key problem is how to prune the big search space in order to get an optimized query plan for query parallel optimization.
并行查询执行计划的搜索空间里指数级增长,如何高效地裁剪搜索空间是并行查询优化的关键所在。
The search space of parallel query execution plan is exponential complexity. How to prune the search space efficiently is the key problem of parallel query optimization.
当DB 2优化器为一个查询形成查询访问计划时,它将工作划分到多个数据库分区上,这些数据库分区是并行工作的。
When the DB2 optimizer forms a query access plan for a query, it divides the work among the database partitions which work in parallel.
应用推荐