SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX File Attributes

HP NonStop SQL/MX Reference Manual—523725-004

8-8

MAXEXTENTS

MAXEXTENTS is a file attribute that specifies the maximum number of extents that

can be allocated 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 set the MAXEXTENTS attribute for a partition by using the PARTITION clause

with CREATE TABLE or CREATE INDEX.

Unlike 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 can be

allocated. The default is 160.

Considerations for MAXEXTENTS

It is generally not efficient to have partitions with hundreds of extents, so you should

keep MAXEXTENTS well below the allowed maximum value. If necessary, increase

the number of partitions.

MAXEXTENTS num-extents