You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by db...@apache.org on 2018/04/30 15:28:03 UTC
[2/3] trafodion git commit: Incorporate Comments 1
Incorporate Comments 1
Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/f04d557d
Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/f04d557d
Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/f04d557d
Branch: refs/heads/master
Commit: f04d557ddfcb2fe6cc2fafda3679f09305f1db9e
Parents: 2f2c741
Author: liu.yu <qw...@hotmail.com>
Authored: Fri Apr 27 11:29:39 2018 +0800
Committer: liu.yu <qw...@hotmail.com>
Committed: Fri Apr 27 11:29:39 2018 +0800
----------------------------------------------------------------------
.../src/asciidoc/_chapters/sql_statements.adoc | 43 +++++---------------
1 file changed, 11 insertions(+), 32 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/trafodion/blob/f04d557d/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc
----------------------------------------------------------------------
diff --git a/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc b/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc
index dc84dbc..5a76ffb 100644
--- a/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc
+++ b/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc
@@ -446,10 +446,6 @@ ref-spec is:
column-list is:
column-name[, column-name]...
-
-index-name is:
- normal-index-name
- | unique-index-name
```
<<<
@@ -593,26 +589,17 @@ enables all unique indexes on the table.
** ENABLE ALL INDEXES
+
-enables all indexes (including normal indexes and unique indexes) on the table.
+enables all indexes (including both non-unique 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.
+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_
+* ENABLE INDEX _index-name_
+
-enables an unique index on the table.
+enables an index on the table.
* DISABLE ALL [UNIQUE] INDEXES
** DISABLE ALL UNIQUE INDEXES
@@ -621,22 +608,14 @@ disables all unique indexes on the table.
** DISABLE ALL INDEXES
+
-disables all indexes (including normal indexes and unique indexes) on the table.
+disables all indexes (including both non-unique and unique indexes) on the table.
* DISABLE INDEX _index-name_
-
-** DISABLE INDEX _normal-index-name_
+
-disables a normal index on the table.
+disables an index on the table.
The index still exists in the data, but it will not
be chosen by the optimizer as an access path.
-** DISABLE INDEX _unique-index-name_
-+
-disables an unique index on the table.
-The unique index still exists in the data, but it will not
-be chosen by the optimizer as an access path.
-
<<<
* `drop constraint _constraint-name_ [restrict]`
+
@@ -777,7 +756,7 @@ Alter TABLE PRODUCT
ALTER COLUMN vend_id RENAME TO cstm_id;
```
-* The following table _orders_ has two normal indexes
+* The following table _orders_ has two non-unique indexes
(_index_orders1_ and _index_orders2_) and
two unique indexes (_unique_index_orders1_ and _unique_index_orders2_).
@@ -829,7 +808,7 @@ CREATE UNIQUE INDEX UNIQUE_INDEX_ORDERS2 ON TRAFODION.SEABASE.ORDERS
```
+
-Disable one unique index (_unique_index_orders1_) and verify that all normal indexes (_index_orders1_ and _index_orders2_)
+Disable one unique index (_unique_index_orders1_) and verify that all non-unique indexes (_index_orders1_ and _index_orders2_)
and the rest unique index (_unique_index_orders2_) are still enabled.
+
@@ -876,7 +855,7 @@ CREATE UNIQUE INDEX UNIQUE_INDEX_ORDERS2 ON TRAFODION.SEABASE.ORDERS
```
+
-Disable one normal index (_index_orders1_) and verify that the rest normal index (_index_orders2_)
+Disable one non-unique index (_index_orders1_) and verify that the rest non-unique index (_index_orders2_)
and the rest unique index (_unique_index_orders2_) are still enabled.
+
@@ -916,7 +895,7 @@ CREATE UNIQUE INDEX UNIQUE_INDEX_ORDERS2 ON TRAFODION.SEABASE.ORDERS
```
+
-Disable all indexes and verify that all indexes (including normal indexes and unique indexes) are disabled.
+Disable all indexes and verify that all of them (including both non-unique and unique indexes) are disabled.
+
```
@@ -941,7 +920,7 @@ CREATE TABLE TRAFODION.SEABASE.ORDERS
```
+
-Enable all indexes on the table _orders_ and verify the result.
+Enable all indexes and verify the result.
+
```