reservepagegap specified only for the table

The following commands specify a reservepagegap for the table, but do not specify a value in the create index commands:

sp_chgattribute titles, "reservepagegap", 16

create clustered index title_ix on titles(title_id)

create index type_price on titles(type, price)

Table 9-8 shows the values applied when running reorg rebuild or dropping and creating a clustered index.

**Table 9-8: reservepagegap values applied with table-level saved value**
Command	Allpages-locked table	Data-only-locked table
create clustered index or clustered index rebuild due to reorg rebuild	Data and index pages: 16	Data pages: 16 Index pages: 0 (filled extents)
Nonclustered index rebuild	Index pages: 0 (filled extents)	Index pages: 0 (filled extents)

The reservepagegap for the table is applied to both the data and index pages for an allpages-locked table with a clustered index. For a data-only-locked table, the table’s reservepagegap is applied to the data pages, but not to the clustered index pages.