[jira] [Commented] (TRAFODION-3044) Add Syntax and Examples of *ENABLE/DISABLE INDEX (ALTER TABLE Statement)* in Trafodion SQL Reference Manual

[ASF GitHub Bot (JIRA)]

    [ 
https://issues.apache.org/jira/browse/TRAFODION-3044?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16455713#comment-16455713
 ] 

ASF GitHub Bot commented on TRAFODION-3044:
-------------------------------------------

Github user liuyu000 commented on a diff in the pull request:

    https://github.com/apache/trafodion/pull/1542#discussion_r184584478
  
    --- 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.
    --- End diff --
    
    Thanks @DaveBirdsall, I've udpated :)


> 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)