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

SQL/MX File Attributes
HP NonStop SQL/MX Reference Manual—540440-003
8-7
MAXEXTENTS
contains only a small amount of data. You can maximize the use of disk space by
specifying smaller extent sizes if performance is not an issue.
MAXEXTENTS
MAXEXTENTS is a file attribute that specifies the maximum number of extents that
you can allocate for an unpartitioned file or for each partition of a partitioned file.
MAXEXTENTS applies to tables and to indexes.
You set the MAXEXTENTS attribute for a table with CREATE TABLE or ALTER
TABLE. You set the attribute for an index with CREATE INDEX or ALTER INDEX.
You use the PARTITION clause with CREATE TABLE or CREATE INDEX to set
the MAXEXTENTS attribute for a partition.
Unlike the NonStop SQL/MP form of these statements, the SQL/MX’s ALTER
TABLE and ALTER INDEX statements have no PARTONLY clause. When you
supply a new value for attributes, these statements modify the value of the attribute
on all partitions of the table or index.
num-extents
is an integer from 1 to 768 (but not less than the number of extents currently
allocated for the file) that specifies the maximum number of extents that you can
allocate. The default is 160.
Considerations for MAXEXTENTS
It is generally not efficient to have partitions with hundreds of extents, so keep
MAXEXTENTS well below the allowed maximum value. If necessary, increase the
number of partitions.
MAXEXTENTS num-extents