Post reply

Corrupted indexes on just one table

  • September 27, 2006 at 9:27 pm

    #192394

    We have a case where just one table--a heavily used one--keeps getting its indexes corrupted.  This table is part of a large OLTP database--more than 1,000 tables with the database mostly in fourth normal form.

    If we stop everything and rebuild the indexes on this table, things will go fine for ten minutes or so.  Then, things will slow down (extremely) and we find that the indexes are again corrupted.

    What can cause this kind of thing to happen?

    I apologize in advance if this is covered elsewhere in the forum.  I just couldn't find the right reference.

    Thanks for your help.


    Richard D. Cushing
    Sr. Consultant
    SYNGERGISTIC SOFTWARE SOLUTIONS, LLC

  • October 2, 2006 at 7:27 am

    #663572

    Richard

    More information, please.  Is it all the indexes on this table, and if so have you rebuilt them all, including the clustered index (if there is one)?  How do you know that the indexes are corrupt, and which ones?  How are you rebuilding the indexes?  DDL for the table and indexes would also be helpful.

    John

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

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