[ 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)