You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2018/01/28 05:03:00 UTC
[jira] [Commented] (TRAFODION-2929) Add *Rebuild Indexes* for LOAD
Statement in *Trafodion SQL Reference Manual*
[ https://issues.apache.org/jira/browse/TRAFODION-2929?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16342439#comment-16342439 ]
ASF GitHub Bot commented on TRAFODION-2929:
-------------------------------------------
Github user DaveBirdsall commented on a diff in the pull request:
https://github.com/apache/trafodion/pull/1416#discussion_r164289100
--- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_utilities.adoc ---
@@ -1173,6 +1186,362 @@ SQL> POPULATE INDEX index_target_table4 ON target_table4;
SQL> DROP INDEX index_target_table4;
--- SQL operation complete.
```
+
+[[rebuild_indexes_examples]]
+==== Examples of `REBUILD INDEXES`
+
+Suppose that we have following tables:
+
+_source_table_:
+
+```
+SQL>select count(*) from source_table;
+(EXPR)
+--------------------
+ 1000000
+
+--- 1 row(s) selected.
+```
+
+_target_table1_ has the same structure as _target_table2_, here takes _target_table1_ for example:
--- End diff --
Possible wordsmith: "Suppose _target_table1_ and _target_table2_ both have the following structure:"
> Add *Rebuild Indexes* for LOAD Statement in *Trafodion SQL Reference Manual*
> ----------------------------------------------------------------------------
>
> Key: TRAFODION-2929
> URL: https://issues.apache.org/jira/browse/TRAFODION-2929
> Project: Apache Trafodion
> Issue Type: Documentation
> Reporter: Liu Yu
> Assignee: Liu Yu
> Priority: Major
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)