To use reorg rebuild, you must be the table owner or the Database Owner, or have System Administrator privileges.
If you omit the index name, the entire table is rebuilt.
If you specify an index, only that index is rebuilt.
Requirements for using reorg rebuild on an index are less stringent than for tables. The following rules apply:
You do not need to set select into to rebuild an index.
Rebuilding a table requires space for a complete copy of the table. Rebuilding an index works in small transactions, and deallocates pages once they are copied; therefore, the process only needs space for the pages copied on each transaction.
You can rebuild the index on a table while transaction level scans (dirty reads) are active.
