index in Yukon

Hi ,
What is the diff between alter index .. Rebuilt & reorganise
Thanks
ARR
Same as between DBCC DBREINDEX and DBCC INDEXDEFRAG. Rebuild will create and drop (same as if you
executed those two commands). Reorg will "shuffle" the pages so they are (more) contiguous.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Aju" <ajuonline@.yahoo.com> wrote in message news:eFnLaZ%23FFHA.3732@.tk2msftngp13.phx.gbl...
> Hi ,
> What is the diff between alter index .. Rebuilt & reorganise
> Thanks
> ARR
>
|||There are some extras too - with ALTER INDEX you can rebuild an index online
(i.e. with concurrent DML). BOL has all the details.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:#w8NE9#FFHA.208@.TK2MSFTNGP12.phx.gbl...
> Same as between DBCC DBREINDEX and DBCC INDEXDEFRAG. Rebuild will create
and drop (same as if you
> executed those two commands). Reorg will "shuffle" the pages so they are
(more) contiguous.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Aju" <ajuonline@.yahoo.com> wrote in message
news:eFnLaZ%23FFHA.3732@.tk2msftngp13.phx.gbl...
>