Specifies the minimum number of extensions to be assigned to a table or an index the moment it is created.
Number greater than 0 (zero).
| |
TABLES |
INDEXES |
| DBMS |
Usage |
Usage |
| Oracle |
MINEXTENTS parameter for the STORAGE clause |
MINEXTENTS parameter for the STORAGE clause |
| SQL Server |
N/A |
N/A |
| DB2 Universal Database |
N/A |
N/A |
| Informix |
N/A |
N/A |
| DB2 UDB for iSeries |
N/A |
N/A |
| MySQL |
N/A |
N/A |
| PostgreSQL |
N/A |
N/A |
Notes
- The value of this property is only considered when the table is created or when the index is created/reorganizated.
- If no value is specified for this property then no clause that indicates the minimum number of table/index extensions will be generated (there is no default value). Each DBMS, in this case, has its own default values (refer to the DBMS documentation).
- If the value of the property changes then no reorganization is performed (a forced reorganization is necessary in order to put this change into effect).
Objects Tables, Indexes
Initial Size
First Extent Size
Next Extents Percentage Increase