Allows indication of the size of the following extension as a percentage, with respect to the last table extension.
Number greater than or equal to 0 (zero).
| DBMS |
Usage |
| Oracle |
PCTINCREASE parameter for the STORAGE clause |
| SQL Server |
N/A |
| DB2 Universal Database |
N/A |
| Informix |
N/A |
| DB2 UDB for iSeries |
N/A |
Notes:
- The value of this property is only considered when the table is created.
- If no value is specified for this property, then no clause indicating the percentage increase to apply to table 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 takes place (a forced reorganization is necessary in order make this change effective).
Objects: Tables