Github user DaveBirdsall commented on a diff in the pull request:
https://github.com/apache/trafodion/pull/1542#discussion_r184473071
--- 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.
--- End diff --
I have not seen the term "normal indexes" anywhere else. When we feel the
need to distinguish an index that is not unique, we usually just say,
"non-unique indexes". Suggested wordsmith: "enables all indexes (including both
non-unique and unique indexes) on the table".
---
