[
https://issues.apache.org/jira/browse/TRAFODION-3044?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16454607#comment-16454607
]
ASF GitHub Bot commented on TRAFODION-3044:
-------------------------------------------
Github user DaveBirdsall commented on a diff in the pull request:
https://github.com/apache/trafodion/pull/1542#discussion_r184474138
--- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc ---
@@ -576,6 +584,59 @@ the two columns or sets of columns must have the same
characteristics (data type
the foreign key in _table_ is the column being defined; with the foreign
key clause, the foreign key is the column or set of columns specified in
the foreign key clause. for information about _ref-spec_, see references
_ref-spec_ not enforced.
+<<<
+* ENABLE ALL [UNIQUE] INDEXES
+
+** ENABLE ALL UNIQUE INDEXES
++
+enables all unique indexes on the table.
+
+** ENABLE ALL INDEXES
++
+enables all indexes (including normal indexes and unique indexes) on the
table.
+
+* _index-name_
+** _normal-index-name_
++
+is equal to _index-name_, which is an SQL identifier that specifies the
simple name for the index. You cannot qualify index-name with its schema name.
+Indexes have their own name space within a schema,
+so an index name might be the same as a table or constraint name. However,
no two indexes in a schema can have the same name.
+
+** _unique-index-name_
++
+is the name of the unique index.
+
+* ENABLE INDEX _normal-index-name_
++
+enables a normal index on the table.
+
+* ENALBE INDEX _unique-index-name_
++
+enables an unique index on the table.
+
+* DISABLE ALL [UNIQUE] INDEXES
+** DISABLE ALL UNIQUE INDEXES
++
+disables all unique indexes on the table.
+
+** DISABLE ALL INDEXES
++
+disables all indexes (including normal indexes and unique indexes) on the
table.
--- End diff --
Similar remarks here
> Add Syntax and Examples of *ENABLE/DISABLE INDEX (ALTER TABLE Statement)* in
> Trafodion SQL Reference Manual
> -----------------------------------------------------------------------------------------------------------
>
> Key: TRAFODION-3044
> URL: https://issues.apache.org/jira/browse/TRAFODION-3044
> 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)
