Github user liuyu000 commented on a diff in the pull request:
https://github.com/apache/trafodion/pull/1542#discussion_r184584482
--- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc ---
@@ -716,6 +777,222 @@ Alter TABLE PRODUCT
ALTER COLUMN vend_id RENAME TO cstm_id;
```
+* The following table _orders_ has two normal indexes
+(_index_orders1_ and _index_orders2_) and
+two unique indexes (_unique_index_orders1_ and _unique_index_orders2_).
+
++
+```
+SQL>SHOWDDL orders;
+CREATE TABLE TRAFODION.SEABASE.ORDERS
+ (
+ ORDERNUM NUMERIC(6, 0) DEFAULT NULL NOT
SERIALIZED
+ , ORDER_DATE DATE DEFAULT NULL NOT SERIALIZED
+ , DELIV_DATE DATE DEFAULT NULL NOT SERIALIZED
+ , SALESREP NUMERIC(4, 0) DEFAULT NULL NOT
SERIALIZED
+ , CUSTNUM NUMERIC(4, 0) DEFAULT NULL NOT
SERIALIZED
+ )
+ ATTRIBUTES ALIGNED FORMAT
+;
+
+CREATE INDEX INDEX_ORDERS1 ON TRAFODION.SEABASE.ORDERS
+ (
+ ORDER_DATE ASC
+ )
+ ATTRIBUTES ALIGNED FORMAT
+;
+
+CREATE INDEX INDEX_ORDERS2 ON TRAFODION.SEABASE.ORDERS
+ (
+ DELIV_DATE ASC
+ )
+ ATTRIBUTES ALIGNED FORMAT
+;
+
+CREATE UNIQUE INDEX UNIQUE_INDEX_ORDERS1 ON TRAFODION.SEABASE.ORDERS
+ (
+ SALESREP ASC
+ )
+ ATTRIBUTES ALIGNED FORMAT
+;
+
+CREATE UNIQUE INDEX UNIQUE_INDEX_ORDERS2 ON TRAFODION.SEABASE.ORDERS
+ (
+ CUSTNUM ASC
+ )
+ ATTRIBUTES ALIGNED FORMAT
+;
+
+-- GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON
TRAFODION.SEABASE.ORDERS TO DB__ROOT WITH GRANT OPTION;
+
+--- SQL operation complete.
+```
+
++
+Disable one unique index (_unique_index_orders1_) and verify that all
normal indexes (_index_orders1_ and _index_orders2_)
+and the rest unique index (_unique_index_orders2_) are still enabled.
+
++
+```
+SQL>ALTER TABLE ORDERS DISABLE INDEX unique_index_orders1;
+--- SQL operation complete.
+
+SQL>SHOWDDL orders;
+CREATE TABLE TRAFODION.SEABASE.ORDERS
+ (
+ ORDERNUM NUMERIC(6, 0) DEFAULT NULL NOT
SERIALIZED
+ , ORDER_DATE DATE DEFAULT NULL NOT SERIALIZED
+ , DELIV_DATE DATE DEFAULT NULL NOT SERIALIZED
+ , SALESREP NUMERIC(4, 0) DEFAULT NULL NOT
SERIALIZED
+ , CUSTNUM NUMERIC(4, 0) DEFAULT NULL NOT
SERIALIZED
+ )
+ ATTRIBUTES ALIGNED FORMAT
+;
+
+CREATE INDEX INDEX_ORDERS1 ON TRAFODION.SEABASE.ORDERS
+ (
+ ORDER_DATE ASC
+ )
+ ATTRIBUTES ALIGNED FORMAT
+;
+
+CREATE INDEX INDEX_ORDERS2 ON TRAFODION.SEABASE.ORDERS
+ (
+ DELIV_DATE ASC
+ )
+ ATTRIBUTES ALIGNED FORMAT
+;
+
+CREATE UNIQUE INDEX UNIQUE_INDEX_ORDERS2 ON TRAFODION.SEABASE.ORDERS
+ (
+ CUSTNUM ASC
+ )
+ ATTRIBUTES ALIGNED FORMAT
+;
+
+-- GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON
TRAFODION.SEABASE.ORDERS TO DB__ROOT WITH GRANT OPTION;
+
+--- SQL operation complete.
+```
+
++
+Disable one normal index (_index_orders1_) and verify that the rest normal
index (_index_orders2_)
+and the rest unique index (_unique_index_orders2_) are still enabled.
+
++
+```
+SQL>ALTER TABLE ORDERS DISABLE INDEX index_orders1;
+--- SQL operation complete.
+
+SQL>SHOWDDL orders;
+CREATE TABLE TRAFODION.SEABASE.ORDERS
+ (
+ ORDERNUM NUMERIC(6, 0) DEFAULT NULL NOT
SERIALIZED
+ , ORDER_DATE DATE DEFAULT NULL NOT SERIALIZED
+ , DELIV_DATE DATE DEFAULT NULL NOT SERIALIZED
+ , SALESREP NUMERIC(4, 0) DEFAULT NULL NOT
SERIALIZED
+ , CUSTNUM NUMERIC(4, 0) DEFAULT NULL NOT
SERIALIZED
+ )
+ ATTRIBUTES ALIGNED FORMAT
+;
+
+CREATE INDEX INDEX_ORDERS2 ON TRAFODION.SEABASE.ORDERS
+ (
+ DELIV_DATE ASC
+ )
+ ATTRIBUTES ALIGNED FORMAT
+;
+
+CREATE UNIQUE INDEX UNIQUE_INDEX_ORDERS2 ON TRAFODION.SEABASE.ORDERS
+ (
+ CUSTNUM ASC
+ )
+ ATTRIBUTES ALIGNED FORMAT
+;
+
+-- GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON
TRAFODION.SEABASE.ORDERS TO DB__ROOT WITH GRANT OPTION;
+
+--- SQL operation complete.
+```
+
++
+Disable all indexes and verify that all indexes (including normal indexes
and unique indexes) are disabled.
+
++
+```
+SQL>ALTER TABLE ORDERS DISABLE ALL INDEXES;
+--- SQL operation complete.
+
+SQL>SHOWDDL orders;
+CREATE TABLE TRAFODION.SEABASE.ORDERS
+ (
+ ORDERNUM NUMERIC(6, 0) DEFAULT NULL NOT
SERIALIZED
+ , ORDER_DATE DATE DEFAULT NULL NOT SERIALIZED
+ , DELIV_DATE DATE DEFAULT NULL NOT SERIALIZED
+ , SALESREP NUMERIC(4, 0) DEFAULT NULL NOT
SERIALIZED
+ , CUSTNUM NUMERIC(4, 0) DEFAULT NULL NOT
SERIALIZED
+ )
+ ATTRIBUTES ALIGNED FORMAT
+;
+
+-- GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON
TRAFODION.SEABASE.ORDERS TO DB__ROOT WITH GRANT OPTION;
+
+--- SQL operation complete.
+```
+
++
+Enable all indexes on the table _orders_ and verify the result.
+
++
+```
+SQL>ALTER TABLE orders ENABLE ALL INDEXES;
+--- SQL operation complete.
+
+SQL>SHOWDDL orders;
+CREATE TABLE TRAFODION.SEABASE.ORDERS
+ (
+ ORDERNUM NUMERIC(6, 0) DEFAULT NULL NOT
SERIALIZED
+ , ORDER_DATE DATE DEFAULT NULL NOT SERIALIZED
+ , DELIV_DATE DATE DEFAULT NULL NOT SERIALIZED
+ , SALESREP NUMERIC(4, 0) DEFAULT NULL NOT
SERIALIZED
+ , CUSTNUM NUMERIC(4, 0) DEFAULT NULL NOT
SERIALIZED
+ )
+ ATTRIBUTES ALIGNED FORMAT
+;
+
+CREATE INDEX INDEX_ORDERS1 ON TRAFODION.SEABASE.ORDERS
+ (
+ ORDER_DATE ASC
+ )
+ ATTRIBUTES ALIGNED FORMAT
+;
+
+CREATE INDEX INDEX_ORDERS2 ON TRAFODION.SEABASE.ORDERS
+ (
+ DELIV_DATE ASC
+ )
+ ATTRIBUTES ALIGNED FORMAT
+;
+
+CREATE UNIQUE INDEX UNIQUE_INDEX_ORDERS1 ON TRAFODION.SEABASE.ORDERS
+ (
+ SALESREP ASC
+ )
+ ATTRIBUTES ALIGNED FORMAT
+;
+
+CREATE UNIQUE INDEX UNIQUE_INDEX_ORDERS2 ON TRAFODION.SEABASE.ORDERS
+ (
+ CUSTNUM ASC
+ )
+ ATTRIBUTES ALIGNED FORMAT
+;
+
+-- GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON
TRAFODION.SEABASE.ORDERS TO DB__ROOT WITH GRANT OPTION;
+
+--- SQL operation complete.
+```
+
--- End diff --
Thanks @DaveBirdsall :)
---
