Export (0) Print
Expand All

Reorganize Index Task

The Reorganize Index task reorganizes indexes in SQL Server database tables and views. For more information about managing indexes, see Reorganize and Rebuild Indexes.

By using the Reorganize Index task, a package can reorganize indexes in a single database or multiple databases. If the task reorganizes only the indexes in a single database, you can choose the views or the tables whose indexes the task reorganizes. The Reorganize Index task also includes an option to compact large object data. Large object data is data with the image, text, ntext, varchar(max), nvarchar(max), varbinary(max), or xml data type. For more information, see Data Types (Transact-SQL).

The Reorganize Index task encapsulates the Transact-SQL ALTER INDEX statement. If you choose to compact large object data, the statement uses the REORGANIZE WITH (LOB_COMPACTION = ON) clause, otherwise LOB_COMPACTION is set to OFF. For more information, see ALTER INDEX (Transact-SQL).

Important note Important

The time the task takes to create the Transact-SQL statement that the task runs is proportionate to the number of indexes the task reorganizes. If the task is configured to reorganize indexes in all the tables and views in a database that holds a large number of indexes, or to reorganize indexes in multiple databases, the task can take a considerable amount of time to generate the Transact-SQL statement.

You can set properties through SSIS Designer. This task is in the Maintenance Plan Tasks section of the Toolbox in SSIS Designer.

For information about the properties that you can set in SSIS Designer, click the following topic:

For more information about how to set these properties in SSIS Designer, see Set the Properties of a Task or Container.

Integration Services icon (small)  Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN:


For automatic notification of these updates, subscribe to the RSS feeds available on the page.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft