Matching options and goals

To redistribute the data pages of a table, leaving room for later expansion:

To create a clustered index without copying data pages:

To use the sorted_data option following a bulk-copy operation, a select into command, or another command that uses extent allocation, set the reservepagegap value that you want for the data pages before copying the data, or specify it in the select into command. Once the data pages have been allocated and filled, the following command applies reservepagegap to the index pages only, since the data pages do not need to be copied:

create clustered index title_ix 
on titles(title_id) 
with sorted_data, reservepagegap = 32