SQL/MP to SQL/MX Database and Application Migration Guide

Converting SQL/MP Tables to SQL/MX Tables
HP NonStop SQL/MP to NonStop SQL/MX Database and Application Migration Guide—666211-001
5-12
Indexes
In SQL/MX indexes, you can set some of the SQL/MP index attributes, as described in
Table 5-4
.
Table 5-3. Differences Between SQL/MP and SQL/MX Indexes
Index Characteristic NonStop SQL/MP NonStop SQL/MX
Index table access Supports WITH SHARED
ACCESS
Does not support WITH
SHARED ACCESS
Partition changes Supports only range
partitioning
Supports range, decoupled
range, and hash
partitioning
Populating indexes Populates the index with
data from the table when
the CREATE INDEX
statement executes
Provides the NO
POPULATE option, which
allows you to defer
populating the index. You
can later populate the
index by using the
POPULATE INDEX utility.
Parallel execution Allows you to specify
PARALLEL EXECUTION
ON or OFF for parallel
index loading
The system determines
whether to perform parallel
index loading.
Invalidate option Allows you to control
whether changes to
indexes cause similarity
checks and automatic
recompilation with the
INVALIDATE option
Does not allow you to
control similarity checks of
indexes with an
INVALIDATE option
Index table attribute See Table 5-4
on
page 5-12.
See Table 5-4 on
page 5-12.
Table 5-4. Index Table Attributes in NonStop SQL/MP and NonStop
SQL/MX (page1of2)
SQL/MP Attributes Supported in SQL/MX?
ALLOCATE Yes
AUDITCOMPRESS Yes
BLOCKSIZE Yes (only 4096)
BUFFERED No
CLEARONPURGE Yes
DCOMPRESS No
EXTENT Yes
FORMAT No (SQL/MX tables are always format 2.)
ICOMPRESS No