To change the reserve page gap for the titles table to 20, enter:
sp_chgattribute more_titles, "reservepagegap", 20
This command sets the reserve page gap for the index title_ix to 10:
sp_chgattribute "titles.title_ix", "reservepagegap", 10
sp_chgattribute changes only values in system tables; data is not moved on data pages as a result of running the procedure. Changing reservepagegap for a table affects future storage as follows:
When data is bulk-copied into the table, the reserve page gap is applied to all newly allocated space, but the storage of existing pages is not affected.
Any command that copies the table’s data to create a new version of the table applies the reserve page gap during the data copy phase of the operation. For example, using reorg rebuild or using alter table to change the locking or partitioning scheme of a table or any change of schema that requires a data copy both apply to reserver page gap.
When you create a clustered index, the reserve page gap value stored for the table is applied to the data pages.
The reserve page gap is applied to index pages during:
alter table...lock, indexes are rebuilt.
The index rebuild phase during reorg rebuild when using alter table to change the locking or partitioning scheme of a table, or when changing any schema that requires a data copy.
create clustered index and alter table commands that create a clustered index, as nonclustered indexes are rebuilt