The on-disk size of a
A
Define 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.