Specifies the initial tables/indexes storage size expressed in KBytes.
Number of storage Kbytes to assign to the table/index when created.
| DBMS |
TABLES |
INDEXES |
| Oracle |
INITIAL parameter for the STORAGE clause of the CREATE TABLE command. |
INITIAL parameter for the STORAGE clause of the CREATE INDEX command or the PRIMARY KEY clause of the CREATE TABLE command. |
| SQL Server |
N/A |
N/A |
| DB2 Universal Database |
N/A |
N/A |
| Informix |
EXTENT SIZE clause of the CREATE TABLE command. |
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/index is created or reorganized.
- If no value is specified for this property then no clause that indicates the initial size of the table/index 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
First Extent Size
Next Extents Percentage Increase
Minimum Number of Extents