ODBC Server Reference Manual

Transact-SQL Language

HP NonStop ODBC Server Reference Manual—429151-002

4-51

CREATE INDEX

Use CREATE INDEX to create indexes.

The CREATE INDEX statement has the following syntax:

UNIQUE

specifies that two or more rows of the table cannot have the same values for the

indexed columns.

CLUSTERED, NONCLUSTERED

indicates whether the physical order of rows in the table is controlled by the index.

Clustered indexes are not supported. CLUSTERED, if specified, is ignored. No

error messages are generated, and the index remains nonclustered.

index-name

is the index to create.

table-name

the table in which the indexed column or columns are located. The table-name

can be qualified with the database and owner.

column-name

is the column or columns to which the index applies.

In SQL Server, you can specify up to 16 columns. In NonStop SQL/MP, however,

the number of columns that can be indexed depends on the length of the index

key. For more information, see the NonStop SQL/MP Reference manual.

CREATE [ UNIQUE ] { CLUSTERED } INDEX index-name

{ NONCLUSTERED }

ON [ [database.]owner. ] table-name

( column-name [ , column-name ] ... )

[ WITH index-option [ , index-option ] ... ]

index-option is:

{ FILLFACTOR = fill }

{ IGNORE DUP KEY }

{ IGNORE DUP ROW }

{ ALLOW DUP ROW }