SQL Server Performance

How to Rebuild indexes in SQL server 2000

Discussion in 'Performance Tuning for DBAs' started by mpolaiah, May 5, 2009.

  1. mpolaiah New Member

    Hi all
    How to Rebuild indexes in SQL server 2000
  2. Sandy New Member

  3. FrankKalis Moderator

    See if this helps: http://technet.microsoft.com/en-us/library/cc966523.aspx
  4. FrankKalis Moderator

    Oops, should have refreshed the page before posting. [:)]
  5. Sandy New Member

    <P mce_keep="true">&nbsp;[quote user="FrankKalis"] <P>Oops, should have refreshed the page before posting. <IMG alt=Smile src="http://sql-server-performance.com/Community/emoticons/emotion-1.gif"> <BR></P>[/quote] <P mce_keep="true">[:D] [:O] [:p] He he he...lolz</P><P mce_keep="true">&nbsp;</P>
  6. dhamu294 New Member

    hi use this statements to rebuild the index.
    DBCC DBREINDEX and DBCC INDEXDEFRAG

Share This Page