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 3-8 shows the values applied when running reorg rebuild or dropping and creating a clustered index.
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) |
For an allpages-locked table with a clustered index, reservepagegap is applied to both the data and index pages. For a data-only-locked table, reservepagegap is applied to the data pages, but not to the clustered index pages.