Using reorg rebuild on data-only-locked tables

The reorg rebuild command copies data rows in data-only-locked tables to new data pages. If there is a clustered index, rows are copied in clustered key order.

Running reorg rebuild redistributes data evenly on partitions. The clustered index and any nonclustered indexes are rebuilt. To run reorg rebuild on the table, provide only the table name:

reorg rebuild titles