Repository: trafodion Updated Branches: refs/heads/master 47713b967 -> 4ef8055f0
Add *Rebuild Indexes* for LOAD Statement in *Trafodion SQL Reference Manual* Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/9d81ec62 Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/9d81ec62 Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/9d81ec62 Branch: refs/heads/master Commit: 9d81ec62ac96dbc529faa9cd911b38ddc3e97f4b Parents: 0edae94 Author: liu.yu <[email protected]> Authored: Fri Jan 26 14:00:00 2018 +0800 Committer: liu.yu <[email protected]> Committed: Fri Jan 26 14:00:00 2018 +0800 ---------------------------------------------------------------------- .../src/asciidoc/_chapters/sql_utilities.adoc | 13 +++++++++++++ 1 file changed, 13 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/trafodion/blob/9d81ec62/docs/sql_reference/src/asciidoc/_chapters/sql_utilities.adoc ---------------------------------------------------------------------- diff --git a/docs/sql_reference/src/asciidoc/_chapters/sql_utilities.adoc b/docs/sql_reference/src/asciidoc/_chapters/sql_utilities.adoc index 8f3408e..eb6110d 100644 --- a/docs/sql_reference/src/asciidoc/_chapters/sql_utilities.adoc +++ b/docs/sql_reference/src/asciidoc/_chapters/sql_utilities.adoc @@ -415,6 +415,7 @@ option is: | NO DUPLICATE CHECK | NO OUTPUT | INDEX TABLE ONLY + | REBUILD INDEXES ``` [[load_syntax]] @@ -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, +in this case, the elapsed time of using LOAD Statement without options is nearly equal to +using LOAD WITH REBUILD INDEXES, and the elapsed time of the former is less than the latter +if this CQD is turned ON. + <<< [[load_considerations]] === Considerations for LOAD
