Matching options and goals

If you want to redistribute the data pages of a table, leaving room for later expansion:

To create a clustered index without copying data pages:

If you plan 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