[ https://issues.apache.org/jira/browse/TRAFODION-2929?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16342902#comment-16342902 ]
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_r164336688 --- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_utilities.adoc --- @@ -517,6 +518,18 @@ Bulk Loader is executing. specifies that the target table, which is an index, be populated with data from the parent table. +** `REBUILD INDEXES` ++ +specifies that indexes of the target table will be updated automatically when the source table +is updated. ++ +This is the default behavior of the LOAD Statement, that is, even if this option is not +specified, the LOAD Statement will rebuild indexes except the +CQD `TRAF_LOAD_ALLOW_RISKY_INDEX_MAINTENANCE` is turned *ON*. This CQD is turned *OFF* by default, --- 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)