difference between dbreindex and drop existing clause of create index

Hi all,
Could any one of you tell me if there is any difference
between dbcc dbreindex and create index with drop_existing
option for a table with one clustered index and multiple
non clustered indexes..?
Also, please let me know what is the best way to reduce
fragmentation in tables that do not have non-clustered
indexes...?bharath,
A light view of the differences can be found at:
Rebuilding an Index
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/createdb/cm_8_des_05_271x.asp
For rebuilding several indexes I would stick with DBCC as a general rule.
The create index ... drop_existing requires that you have all the metadata
for the indexes in your script. The DBCC requires you to know nothing more
than the table that you are concerned with. As I understand it, both should
use parallel processing if available.
Russell Fields
"bharath" <barathsing@.hotmail.com> wrote in message
news:88ef01c3b57b$fdcc37d0$a601280a@.phx.gbl...
> Hi all,
> Could any one of you tell me if there is any difference
> between dbcc dbreindex and create index with drop_existing
> option for a table with one clustered index and multiple
> non clustered indexes..?
> Also, please let me know what is the best way to reduce
> fragmentation in tables that do not have non-clustered
> indexes...?

diff between dbcc indexdefrag & dbreindex

Hi ,
The above said diff. please
which is suitable for OLTP DBS & DATA
Thanks
Ajay
HI Ajay
This article covers the differences in detail:
http://www.microsoft.com/technet/pro.../ss2kidbp.mspx
HTH
Regards,
Greg Linwood
SQL Server MVP
"Aju" <ajuonline@.yahoo.com> wrote in message
news:ONipJ40gEHA.4092@.TK2MSFTNGP10.phx.gbl...
> Hi ,
> The above said diff. please
> which is suitable for OLTP DBS & DATA
> Thanks
> Ajay
>
|||> This article covers the differences in detail:
> http://www.microsoft.com/technet/pro.../ss2kidbp.mspx
also:
http://www.sql-server-performance.co...gmentation.asp
RADl0PASlV

diff between dbcc indexdefrag & dbreindex

Hi ,
The above said diff. please
which is suitable for OLTP DBS & DATA
Thanks
AjayHI Ajay
This article covers the differences in detail:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
HTH
Regards,
Greg Linwood
SQL Server MVP
"Aju" <ajuonline@.yahoo.com> wrote in message
news:ONipJ40gEHA.4092@.TK2MSFTNGP10.phx.gbl...
> Hi ,
> The above said diff. please
> which is suitable for OLTP DBS & DATA
> Thanks
> Ajay
>|||> This article covers the differences in detail:
> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
also:
http://www.sql-server-performance.com/rd_index_fragmentation.asp
RADl0PASlV

diff between dbcc indexdefrag & dbreindex

Hi ,
The above said diff. please
which is suitable for OLTP DBS & DATA
Thanks
AjayHI Ajay
This article covers the differences in detail:
http://www.microsoft.com/technet/pr...n/ss2kidbp.mspx
HTH
Regards,
Greg Linwood
SQL Server MVP
"Aju" <ajuonline@.yahoo.com> wrote in message
news:ONipJ40gEHA.4092@.TK2MSFTNGP10.phx.gbl...
> Hi ,
> The above said diff. please
> which is suitable for OLTP DBS & DATA
> Thanks
> Ajay
>|||> This article covers the differences in detail:[vbcol=seagreen]
> http://www.microsoft.com/technet/pr...n/ss2kidbp.mspx[/vbco
l]
also:
http://www.sql-server-performance.c...agmentation.asp
RADl0PASlV