Post reply

Index rebuilt verify

  • December 13, 2009 at 6:32 am

    #156496

    Hi,

    How to verify that an index has been rebuilt. Is there any updated time so that we can come know that it has been rebuilt.

    Any system table?

    Thanks in advance.

  • December 13, 2009 at 7:24 am

    #1091651

    You might wantto review this dynamic management view before and after your rebuild

    SQL Server 2005 Books Online (September 2007)

    sys.dm_db_index_physical_stats

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • December 13, 2009 at 12:41 pm

    #1091696

    I am not aware of anything that tells you an actual date when a rebuild was run, but if rebuild has been run then the statistics will also have been updated so that is a possible indicator.

    Use the stats_date function or dbcc show_statistics to get the date update stats was last run.

    ---------------------------------------------------------------------

  • December 14, 2009 at 4:06 am

    #1091840

    Hi,

    How u r rebuild the indexes through maintenance plan ?

    How to verify that an index has been rebuilt. Is there any updated time so that we can come know that it has been rebuilt.

    Also,I'd suggested read the 1'st link added in my signature.

    I wrote custom index rebuild script that maintaining the history table.

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • December 14, 2009 at 5:07 am

    #1091862

    By using manual drop and create index script!

    SQL Server version 2000.

  • December 14, 2009 at 5:53 am

    #1091884

    mahesh.vsp (12/14/2009)

    By using manual drop and create index script!

    SQL Server version 2000.

    Then why u r posting in 2005 forum.

    --Please post the 2000 related question in 2000 forum

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • December 17, 2009 at 6:24 am

    #1093455

    Hi muthu,

    i thought of posting it in sql 2000 only. it was my bad!

    do u know how to do it in 2000?

  • December 17, 2009 at 8:11 am

    #1093517

    mahesh.vsp (12/17/2009)

    Hi muthu,

    i thought of posting it in sql 2000 only. it was my bad!

    do u know how to do it in 2000?

    Search under the Script section in our SSC .

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • December 19, 2009 at 11:47 am

    #1094476

    Thank you.

  • December 19, 2009 at 10:25 pm

    #1094490

    mahesh.vsp (12/19/2009)

    Thank you.

    Ur welcome...:-D

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply