reservepagegap specified for a clustered index

These commands specify different reservepagegap values for the table and the clustered index, and a value for the nonclustered type_price index:

sp_chgattribute titles, "reservepagegap", 16

create clustered index title_ix on titles(title)
    with reservepagegap = 20

create index type_price on titles(type, price)
    with reservepagegap = 24

Table 9-9 shows the effects of this sequence of commands.

**Table 9-9: reservepagegap values applied with for index pages**
Command	Allpages-locked table	Data-only-locked table
create clustered index or clustered index rebuild due to reorg rebuild	Data and index pages: 20	Data pages: 16 Index pages: 20
Nonclustered index rebuilds	Index pages: 24	Index pages: 24

For allpages-locked tables, the reservepagegap specified with create clustered index applies to both data and index pages. For data-only-locked tables, the reservepagegap specified with create clustered index applies only to the index pages. If there is a stored reservepagegap value for the table, that value is applied to the data pages.