ODBC Server Reference Manual

CORE SQL Language

HP NonStop ODBC Server Reference Manual—429151-002

3-38

CORE SQL Compared With NonStop SQL/MP

The corresponding NonStop SQL/MP statement is CREATE INDEX.

CREATE INDEX in CORE SQL differs from the NonStop SQL/MP implementation in

the following ways:

Feature In NonStop SQL/MP In CORE SQL

Can you create partitioned

indexes?

Yes No, unless you use pass-

through mode.

Can you specify partition

attributes?

Yes No, NonStop SQL/MP defaults

are taken unless you use pass-

through mode.

Can you specify file attributes? Yes No, NonStop SQL/MP defaults

are taken unless you use pass-

through mode.

Can you specify the physical

location of the index?

Yes No, unless you use pass-

through mode. You can create

an index only on the

subvolume that holds the

catalog in which the index will

be registered.

Can you create a clustered

index?

Yes No, unless you use pass-

through mode.

Can you create a UNIQUE

index on a nullable column?

No Yes