SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-57
Considerations for CREATE INDEX
file-name
is an optional Guardian file name. file-name names must be 8
characters in length and must end with the digits “00” (zero zero.)
Any Guardian file name you specify must match the designated schema
subvolume name for the schema in which the object is being created.
Otherwise, NonStop SQL/MX returns an error.
partition-name
is an SQL identifier for a partition.
partn-file-option is an SQL/MX extension.
See PARTITION Clause on page 7-5.
ATTRIBUTE[S] attribute [,attribute]...
specifies file attributes for the key-sequenced file that holds the index. In an
ATTRIBUTES clause that is within a PARTITION clause, you must separate
attributes with a space. In ATTRIBUTES clauses in other places, you can
separate attributes with either a space or a comma. File attributes you can
specify are:
Attributes marked with an asterisk (*) default to the same value as the
corresponding attribute in the underlying table. For more detail, see the entry for a
specific attribute.
Considerations for CREATE INDEX
If you are creating an index on a large SQL/MX table that is already populated, you
should use the NO POPULATE option, and then run the POPULATE INDEX utility to
load the index. Because CREATE INDEX executes in a single TMF transaction, it
could experience TMF limitations such as a transaction timeout if a large amount of
data is to be moved. Fore more information about creating and populating indexes, see
the SQL/MX Installation and Management Guide.
ALLOCATE/DEALLOCATE
on page 8-2
Controls amount of disk space allocated.
AUDITCOMPRESS on
page 8-3
Controls whether unchanged columns are included
in audit records.
BLOCKSIZE on page 8-4 Sets size of data blocks. 4096 is the only supported
value.
CLEARONPURGE on
page 8-5 *
Controls disk erasure when index is dropped.
EXTENT
on page 8-6 Controls size of extents that are allocated on disk.
MAXEXTENTS on
page 8-7
Controls maximum disk space to be allocated.