To use reorg rebuild, you must be the table owner or the database owner, or have system administrator privileges.
If you omit the index or partition name, the entire table is rebuilt.
If you specify an index, only that index is rebuilt. Similarly, if you specify an index partition, only that index partition 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 needs space only for the pages copied on each transaction.
You can rebuild the index on a table while transaction level scans (dirty reads) are active.
