SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-145
CREATE INDEX Statement
In all other cases, the default is INVALIDATE.
KEYTAG key-specifier
specifies a two-byte key specifier unique among indexes for the table that is stored
in every row of the index.
If you omit the KEYTAG clause, SQL generates a keytag for the table.
System-generated keytags are sequential numbers, beginning with one.
User-specified keytag values can be either two bytes of character data or a
SMALLINT UNSIGNED value in the range 1 through 65535.
PARALLEL EXECUTION { ON [ CONFIG file ] | OFF }
specifies whether to load partitions of a partitioned index in parallel. (The
PARALLEL EXECUTION clause has no effect when you create an index on an
empty table.)
PARALLEL EXECUTION ON directs SQL to load index partitions in parallel.
PARALLEL EXECUTION OFF, the default, directs SQL to load index partitions
serially.
file is the name of an EDIT file (or an equivalent DEFINE) that contains
instructions for configuring the processes that load the index. For more information
about how to specify configuration instructions in file, see Parallel Index Loading
on page P-5.
If table and index are not partitioned, sorting by subsort process is usually
faster than the PARALLEL EXECUTION option. (Sorting by subsorts is not
recommended if the index is partitioned and parallel processing is used.) You
configure subsorts with class SUBSORT DEFINEs and the SUBSORT attribute of
the =_SORT_DEFAULTS DEFINE. For more information on configuring subsorts,
see the FastSort Manual. See Examples—CREATE INDEX
on page C-150.
PARTITION ( partition [ , partition ] ... )
defines secondary partitions for a partitioned index.
partition is the definition of a single secondary partition and includes the
location of the partition, the first key value for the partition, and (optionally) the
catalog, physical volume, and EXTENT, MAXEXTENT, and FORMAT values for the
partition. For information on this clause, see PARTITION Clause
on page P-16.