The on-disk size of a
To pre-allocate pages, specify the property prior to the CREATE TABLE or CREATE INDEX statement. The property value defines the number of user pages the table or index is to be created with. The purpose of this property is to preallocate a table or index of reasonable size if the user expects that a large amount of data will be inserted into the table or index. A table or index that has the pre-allocated pages will enjoy a small performance improvement over a table or index that has no pre-allocated pages when the data are loaded.
The total desired size of the table or index should be the following number of bytes:
When you create a table or an index after setting this property,
1 page.
The minimum number of initialPages is 1.
The maximum number of initialPages is 1000.
This property is static; if you change it while