Github user dyozie commented on a diff in the pull request:
https://github.com/apache/incubator-hawq-docs/pull/60#discussion_r87923659
--- Diff: query/gporca/query-gporca-enable.html.md.erb ---
@@ -20,35 +20,45 @@ As part of routine database maintenance, you should
refresh statistics on the ro
When the configuration parameter `optimizer_analyze_root_partition` is set
to `on`, root partition statistics will be collected when `ANALYZE` is run on a
partitioned table. Root partition statistics are required by GPORCA.
-1. Log into the HAWQ master host as `gpadmin`, the HAWQ administrator.
-2. Set the values of the server configuration parameters. These HAWQ
`hawq config` utility commands sets the value of the parameters to
`on`:
+You will perform different procedures to set optimizer configuration
parameters for your whole HAWQ cluster depending upon whether you manage your
cluster from the command line or use Ambari. If you use Ambari to manage your
HAWQ cluster, you must ensure that you update server configuration parameters
via the Ambari Web UI only. If you manage your HAWQ cluster from the command
line, you will use the `hawq config` command line utility to set optimizer
server configuration parameters.
--- End diff --
See previous edits.
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---
