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
    mpolaiah, May 5, 2009
    #2

  2. Sandy New Member

    Sandy, May 5, 2009
    #3

  3. FrankKalis Moderator

    See if this helps: http://technet.microsoft.com/en-us/library/cc966523.aspx
    FrankKalis, May 5, 2009
    #4

  4. FrankKalis Moderator

    Oops, should have refreshed the page before posting. [:)]
    FrankKalis, May 5, 2009
    #5

  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>
    Sandy, May 5, 2009
    #6

  6. dhamu294 New Member

    hi use this statements to rebuild the index.
    DBCC DBREINDEX and DBCC INDEXDEFRAG
    dhamu294, May 5, 2009
    #7

Share This Page