Author: jamestaylor
Date: Sat May 21 16:36:37 2016
New Revision: 1744962
URL: http://svn.apache.org/viewvc?rev=1744962&view=rev
Log:
Add documentation for SET option to UPDATE STATISTICS
Modified:
phoenix/phoenix-docs/src/docsrc/help/phoenix.csv
phoenix/phoenix-docs/src/tools/org/h2/build/doc/dictionary.txt
phoenix/site/publish/language/datatypes.html
phoenix/site/publish/language/functions.html
phoenix/site/publish/language/index.html
Modified: phoenix/phoenix-docs/src/docsrc/help/phoenix.csv
URL:
http://svn.apache.org/viewvc/phoenix/phoenix-docs/src/docsrc/help/phoenix.csv?rev=1744962&r1=1744961&r2=1744962&view=diff
==============================================================================
--- phoenix/phoenix-docs/src/docsrc/help/phoenix.csv (original)
+++ phoenix/phoenix-docs/src/docsrc/help/phoenix.csv Sat May 21 16:36:37 2016
@@ -269,18 +269,21 @@ CONSTRAINT my_pk PRIMARY KEY (host ASC,c
"
"Commands","UPDATE STATISTICS","
-UPDATE STATISTICS tableRef [ALL | INDEX | COLUMNS]
+UPDATE STATISTICS tableRef [ALL | INDEX | COLUMNS] [SET guidepostOptions]
","
Updates the statistics on the table and by default all of its associated index
tables. To only
update the table, use the COLUMNS option and to only update the INDEX, use the
INDEX option.
-Note that the statistics for a single index may also be updated by using its
full index name
-for the tableRef.
+The statistics for a single index may also be updated by using its full index
name for the tableRef.
+The default guidepost properties may be overridden by specifying their values
after the SET
+keyword. Note that when a major compaction occurs, the default guidepost
properties will be
+used again.
","
UPDATE STATISTICS my_table
UPDATE STATISTICS my_schema.my_table INDEX
UPDATE STATISTICS my_index
UPDATE STATISTICS my_table COLUMNS
+UPDATE STATISTICS my_table SET phoenix.stats.guidepost.width=50000000
"
"Other Grammar","Options","
Modified: phoenix/phoenix-docs/src/tools/org/h2/build/doc/dictionary.txt
URL:
http://svn.apache.org/viewvc/phoenix/phoenix-docs/src/tools/org/h2/build/doc/dictionary.txt?rev=1744962&r1=1744961&r2=1744962&view=diff
==============================================================================
--- phoenix/phoenix-docs/src/tools/org/h2/build/doc/dictionary.txt (original)
+++ phoenix/phoenix-docs/src/tools/org/h2/build/doc/dictionary.txt Sat May 21
16:36:37 2016
@@ -729,3 +729,4 @@ rpc doled paranthesis reaching satisfy c
guideposts collects ilike rhs uniformly ttl reviewer ranking earth
hdfs myjar myincrement defaultvalue defualtvalue mypackage raised logarithm
euler cbrt
transitioned overriden removal serially parallelized opposed frequency namely
tranactional istransactional
+guidepost compaction
Modified: phoenix/site/publish/language/datatypes.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/language/datatypes.html?rev=1744962&r1=1744961&r2=1744962&view=diff
==============================================================================
--- phoenix/site/publish/language/datatypes.html (original)
+++ phoenix/site/publish/language/datatypes.html Sat May 21 16:36:37 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-04-28
+ Generated by Apache Maven Doxia at 2016-05-21
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/language/functions.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/language/functions.html?rev=1744962&r1=1744961&r2=1744962&view=diff
==============================================================================
--- phoenix/site/publish/language/functions.html (original)
+++ phoenix/site/publish/language/functions.html Sat May 21 16:36:37 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-04-28
+ Generated by Apache Maven Doxia at 2016-05-21
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/language/index.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/language/index.html?rev=1744962&r1=1744961&r2=1744962&view=diff
==============================================================================
--- phoenix/site/publish/language/index.html (original)
+++ phoenix/site/publish/language/index.html Sat May 21 16:36:37 2016
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2016-04-28
+ Generated by Apache Maven Doxia at 2016-05-21
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -834,21 +834,21 @@ EXPLAIN SELECT NAME, COUNT(*) FROM TEST
<h3 id="update_statistics" class="notranslate">UPDATE STATISTICS</h3>
<!-- railroad-start -->
<pre name="bnf" style="display: none">
-UPDATE STATISTICS <a href="index.html#table_ref">tableRef</a> [ALL | INDEX |
COLUMNS]
+UPDATE STATISTICS <a href="index.html#table_ref">tableRef</a> [ALL | INDEX |
COLUMNS] [SET <a href="index.html#options">guidepostOptions</a>]
</pre>
<div name="railroad">
-<table class="railroad"><tr class="railroad"><td class="d"><code
class="c">UPDATE STATISTICS <a
href="index.html#table_ref">tableRef</a></code></td><td class="d"><table
class="railroad"><tr class="railroad"><td class="ts"></td><td
class="d"> </td><td class="te"></td></tr><tr class="railroad"><td
class="ls"></td><td class="d"><table class="railroad"><tr class="railroad"><td
class="ts"></td><td class="d"><code class="c">ALL</code></td><td
class="te"></td></tr><tr class="railroad"><td class="ks"></td><td
class="d"><code class="c">INDEX</code></td><td class="ke"></td></tr><tr
class="railroad"><td class="ls"></td><td class="d"><code
class="c">COLUMNS</code></td><td class="le"></td></tr></table></td><td
class="le"></td></tr></table></td></tr></table>
+<table class="railroad"><tr class="railroad"><td class="d"><code
class="c">UPDATE STATISTICS <a
href="index.html#table_ref">tableRef</a></code></td><td class="d"><table
class="railroad"><tr class="railroad"><td class="ts"></td><td
class="d"> </td><td class="te"></td></tr><tr class="railroad"><td
class="ls"></td><td class="d"><table class="railroad"><tr class="railroad"><td
class="ts"></td><td class="d"><code class="c">ALL</code></td><td
class="te"></td></tr><tr class="railroad"><td class="ks"></td><td
class="d"><code class="c">INDEX</code></td><td class="ke"></td></tr><tr
class="railroad"><td class="ls"></td><td class="d"><code
class="c">COLUMNS</code></td><td class="le"></td></tr></table></td><td
class="le"></td></tr></table></td><td class="d"><table class="railroad"><tr
class="railroad"><td class="ts"></td><td class="d"> </td><td
class="te"></td></tr><tr class="railroad"><td class="ls"></td><td
class="d"><table class="railroad"><tr class="railroad"><td class="d"><code cl
ass="c">SET <a
href="index.html#options">guidepostOptions</a></code></td></tr></table></td><td
class="le"></td></tr></table></td></tr></table>
</div>
<!-- railroad-end -->
<!-- syntax-start
<pre>
-UPDATE STATISTICS <a href="index.html#table_ref">tableRef</a> [ALL | INDEX |
COLUMNS]
+UPDATE STATISTICS <a href="index.html#table_ref">tableRef</a> [ALL | INDEX |
COLUMNS] [SET <a href="index.html#options">guidepostOptions</a>]
</pre>
syntax-end -->
-<p>Updates the statistics on the table and by default all of its associated
index tables. To only update the table, use the <code>COLUMNS</code> option and
to only update the <code>INDEX</code>, use the <code>INDEX</code> option. Note
that the statistics for a single index may also be updated by using its full
index name for the tableRef.</p>
+<p>Updates the statistics on the table and by default all of its associated
index tables. To only update the table, use the <code>COLUMNS</code> option and
to only update the <code>INDEX</code>, use the <code>INDEX</code> option. The
statistics for a single index may also be updated by using its full index name
for the tableRef. The default guidepost properties may be overridden by
specifying their values after the <code>SET</code> keyword. Note that when a
major compaction occurs, the default guidepost properties will be used
again.</p>
<p>Example:</p>
<p class="notranslate">
-UPDATE STATISTICS my_table<br />UPDATE STATISTICS my_schema.my_table INDEX<br
/>UPDATE STATISTICS my_index<br />UPDATE STATISTICS my_table COLUMNS</p>
+UPDATE STATISTICS my_table<br />UPDATE STATISTICS my_schema.my_table INDEX<br
/>UPDATE STATISTICS my_index<br />UPDATE STATISTICS my_table COLUMNS<br
/>UPDATE STATISTICS my_table SET phoenix.stats.guidepost.width=50000000</p>
<h3 id="constraint" class="notranslate">Constraint</h3>
