[
https://issues.apache.org/jira/browse/TRAFODION-2929?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16342909#comment-16342909
]
ASF GitHub Bot commented on TRAFODION-2929:
-------------------------------------------
Github user liuyu000 commented on a diff in the pull request:
https://github.com/apache/trafodion/pull/1416#discussion_r164338652
--- 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 --
Thanks Dave, your comment has been incorporated :)
> 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)
