Reorganize Index Task

The reorganize index task reorganizes indexes in sql server database tables and views. 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.

Step 1:

Drag and drop reorganize index task and edit it

Step 2:

Give a new connection as reorganize index task

Step 3:

In databases to select a database as AdventureWorks

Step 4:

In selection to select a view as HumanResources.vEmployeeDepartment

Step 5:

Execute a task