Post reply

SQL 6.5 and re-indexing

  • October 25, 2005 at 10:07 am

    #166020

    Our old DBA used to run the command = exec update_all_indexes to reindex the DB.

    Bearing in mind we are using SQL 6.5 - can someone help me please - is this the best way to reindex?

    Thank in advance!

  • October 25, 2005 at 1:49 pm

    #599934

    The answer to your question is probably yes.

    Oh boy 6.5, talk about taxing the memory cells.

    I think what you have is a custom written stored procedure that loops through all the indexes and either drops and recreates them or executes DBCC DBREINDEX ( was that a 6.5 command???).

    Try this via the Query Analyzer.

    use master

    GO

    EXECUTE sp_helptext update_all_indexes

    GO

    if that does not return anything

    use msdb

    GO

    EXECUTE sp_helptext update_all_indexes

    GO

    Look at the code and see what it does.

    Norman

  • October 26, 2005 at 11:34 am

    #600325

    It is undoubtedly a 'custom' SP. My guess is that it came from SWYNK (now SSUG). I remember having to perform the same maintenance many, many moons ago.  Don't forget the update statistics and sp_recompile too !

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 3 posts - 1 through 2 (of 2 total)

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