使用何种类型的并行处理也会受到查询的执行方式的影响。
The type of parallelism used is also influenced by how the query is processed.
CP并行可以在db2子系统中为一条查询使用多个任务,而sysplex查询并行这种方法使一个DB 2数据共享组中的所有成员可以一起处理一个查询。
While query CP parallelism used multi-tasking for a query within a DB2 subsystem, this method enables all the members of a DB2 data-sharing group to process a single query.
您的问题的解决方案是使用更多的碎片,因为所有碎片被并行查询。
The solution to your problem is to use more shards, as all shards are queried in parallel.
应用推荐