Re: index in Yukon

From: Paul S Randal [MS] (prandal_at_online.microsoft.com)
Date: 02/21/05 

Date: Mon, 21 Feb 2005 09:28:58 -0800

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...
> > Hi ,
> > What is the diff between alter index .. Rebuilt  & reorganise
> >
> > Thanks
> > ARR
> >
> >
>
>

Relevant Pages

  • 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: unable to reindex (alter index rebuild) a full-text enabled table
    ... time to do the rebuild decrease? ... columns that are of type text in a SQL Server 2005 x64 EE environment. ... I try to run a "alter index on table ... has anyone had any problems reclaiming space or defragging indexes on ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Indexes
    ... This is typically done using the DBCC DBREINDEX command (in 2005 we use ... ALTER INDEX with the REBUILD option instead). ... An alternative method is DBCC INDEXDEFRAG (ALTER INDEX with the REORGANIZE ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.tools)
  • 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: System drives says it is full but its not
    ... with two other servers recently and had to rebuild the system drives becuase ... the event logs, temp files, and ran a diagnostic for larg files but none were ... This is my SQL server and would really hate to have to rebuild ...
    (microsoft.public.windows.server.general)