Rebuild Index Task
When you insert, update, or delete records from tables, the indexes become fragmented and the performance suffers. To keep the performance at the optimum level, you may decide to rebuild indexes as part of your SSIS package. The Rebuild Index task drops the index and creates a new one using the specified fill factor for SQL Server database tables and views. By rebuilding the index, this task removes fragmentation of pages, compacts the tables, reclaims disk space, and orders the rows in the contiguous pages, thus improving performance. This task effectively runs the ALTER INDEX REBUILD T-SQL command.
Here is the step by step method to configure this task:
1. | Drag the task on the Control Flow Designer panel and start configuring ... |
Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
