Re: index in Yukon

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 02/21/05 

Date: Mon, 21 Feb 2005 09:28:13 +0100

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
>
>

Relevant Pages

  • Re: DBReindex
    ... Only rebuild / reorganize indexes with fragmentation. ... The job I posted was for SQL 2000 - the script was something my predecessor ... I was surprised to discover that dbcc dbreindex may ...
    (microsoft.public.sqlserver.security)
  • Re: DBReindex
    ... dbcc dbreindex routine, I tried to update the dbcc dbreindex command with ... I assume there is a way to rebuild indexes in SQL 2005 but for me it isn't ... Bulk-logged recovery still gives the possibiliy ... You can also consider ALTER INDEX REORGANIZE this command can be ...
    (microsoft.public.sqlserver.security)
  • Re: DBReindex
    ... Only rebuild / reorganize indexes with fragmentation. ... The job I posted was for SQL 2000 - the script was something my predecessor ... I was surprised to discover that dbcc dbreindex may ...
    (microsoft.public.sqlserver.security)
  • Re: index in Yukon
    ... There are some extras too - with ALTER INDEX you can rebuild an index online ... Microsoft SQL Server Storage Engine ... > Same as between DBCC DBREINDEX and DBCC INDEXDEFRAG. ...
    (microsoft.public.sqlserver.server)