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
>