Repository: trafodion Updated Branches: refs/heads/master 8c76c412c -> fb269de14
[TRAFODION-3191] Correct Syntax Descriptions for *DEFAULT_DEGREE_OF_PARALLELISM* in *Trafodion CQD Reference Guide* Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/72b3d667 Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/72b3d667 Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/72b3d667 Branch: refs/heads/master Commit: 72b3d6673013bf06cfc4799a814fcf1d4a3d7145 Parents: 1650c78 Author: liu.yu <qwerty...@hotmail.com> Authored: Tue Aug 28 16:36:03 2018 +0800 Committer: liu.yu <qwerty...@hotmail.com> Committed: Tue Aug 28 16:36:03 2018 +0800 ---------------------------------------------------------------------- docs/cqd_reference/src/asciidoc/_chapters/query_plans.adoc | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/trafodion/blob/72b3d667/docs/cqd_reference/src/asciidoc/_chapters/query_plans.adoc ---------------------------------------------------------------------- diff --git a/docs/cqd_reference/src/asciidoc/_chapters/query_plans.adoc b/docs/cqd_reference/src/asciidoc/_chapters/query_plans.adoc index 2791e96..c1548cb 100644 --- a/docs/cqd_reference/src/asciidoc/_chapters/query_plans.adoc +++ b/docs/cqd_reference/src/asciidoc/_chapters/query_plans.adoc @@ -40,11 +40,11 @@ The optimizer may also decide to run the query with no parallelism if the resour | *Values* | Unsigned Integer. + + -The default value is *'16'*. +The default value is *2*. | *Usage* | For systems running at higher levels of concurrency with workloads that include a large number of small queries, reducing the default degree of parallelism may help achieve higher throughput. + + -With the default of 16, for 32-node systems, adaptive segmentation can use two 16-node virtual segments to execute queries that +If the degree of parallelism is 16, for 32-node systems, adaptive segmentation can use two 16-node virtual segments to execute queries that do not require a degree of parallelism of 32. This default setting can, for example, be changed to 8 for a 16-node system, to allow adaptive segmentation to leverage a lower degree of parallelism.