You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by db...@apache.org on 2016/05/26 15:51:16 UTC

[2/3] incubator-trafodion git commit: Update SQL reference manual.

Update SQL reference manual.


Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/a181789f
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/a181789f
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/a181789f

Branch: refs/heads/master
Commit: a181789f0454f3ebe39f49d4a74c96da96610321
Parents: d7f3891
Author: Dave Birdsall <db...@apache.org>
Authored: Tue May 24 23:24:20 2016 +0000
Committer: Dave Birdsall <db...@apache.org>
Committed: Tue May 24 23:24:20 2016 +0000

----------------------------------------------------------------------
 docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc | 3 +--
 1 file changed, 1 insertion(+), 2 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/a181789f/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc
----------------------------------------------------------------------
diff --git a/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc b/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc
index c498c82..e4156b0 100644
--- a/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc
+++ b/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc
@@ -2593,8 +2593,7 @@ any conflicts.
 * Volatile tables are partitioned by the system. The number of partitions is limited to four partitions by default.
 The partitions will be distributed across the cluster. The default value is four partitions regardless of the system
 configuration.
-* Statistics are not automatically updated for volatile tables. If you need statistics, you must explicitly run
-UPDATE STATISTICS.
+* UPDATE STATISTICS is not supported for volatile tables. If you need statistics, you must use a non-volatile table instead.
 * Volatile tables can be created and accessed using one-part, two-part, or three-part names. However, you must use the
 same name (one part, two part, or three part) for any further DDL or DML statements on the created volatile table.
 See <<create_table_examples,Examples of CREATE TABLE>>.