SQL Data Definition Statements - Database Systems - page 205

Figure 11-15. The Alter-Index Statement (continued)

Figure 11-16. Abridged Version of the Create-Index Statement

Note:

1. The default order is ASC(ending).

2. The (left-right) ordering of the columns in the index is

significant in the usual major-minor convention.

3. The CLUSTER option specifies that this is a clustering index —

index values are clustered.

4. The UNIQUE option specifies that no two rows in the indexed

table will be allowed to have the same value for the index
column(s).