SQL 2005

In a maintenance plan, when would I want to run Rebuild Index Task vs.
Reorganize Index Task? Do I want them both in the same plan, or separate
plans?

Thanks, Andre

I do not recommend you to use both of them automaticly.

Reorganize your indexes when possible. This process is performed online.

Rebuilding your indexes are performed offline.

Especially if it's a production server and being used frequently then you
may have problems if you rebuild your indexes often.

I would suggest you to see more information abour Index Rebuild and Index
Reorganize from the following link:
http://msdn2.microsoft.com/en-us/library/ms188388.aspx

You can learn about the fragmentation values of you indexes using DBCC
SHOWCONTIG or sys.dm_db_index_physical_stats which is new in SQL Server
2005.

For more information about DBCC SHOWCONTIG: (This command will be removed in
the future versions of SQL Server)
http://msdn2.microsoft.com/en-us/library/ms175008.aspx

For more information about sys.dm_db_index_physical_stats:
http://msdn2.microsoft.com/en-us/library/ms188917.aspx

--
Ekrem Önsoy



"Andre" <nospam@spam.com> wrote in message
news:%23G6TY$iCIHA.4196@TK2MSFTNGP04.phx.gbl...
> SQL 2005
>
> In a maintenance plan, when would I want to run Rebuild Index Task vs.
> Reorganize Index Task? Do I want them both in the same plan, or separate
> plans?
>
> Thanks, Andre
>

Great information, thanks much.

Andre

In addition to the information provided by Ekrem, take a look at this
whitepaper:

Microsoft SQL Server 2000 Index Defragmentation Best Practices
http://www.microsoft.com/technet/pro.../ss2kidbp.mspx

Although the title refers to SQL 2000, it is relevant to 2005 as well. It
discusses how to tell when defragmentation will vs a complete
rebuilding of the indexes.
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com


"Andre" <nospam@spam.com> wrote in message
news:OgFlzfoCIHA.748@TK2MSFTNGP04.phx.gbl...
> Great information, thanks much.
>
> Andre
>