Post reply

Dropping indexes

  • April 10, 2007 at 1:36 pm

    #61894

    Hi there,

    Can I drop an index at any time or should I make sure that no transactions are running against the table that relates to the index, before dropping it? Tx.

  • April 10, 2007 at 2:32 pm

    #699640

    Anytime. Might take time if there are transactions open, but no reason not to do it.

  • April 10, 2007 at 3:38 pm

    #699654

    Thanks a bunch Steve. Always wondered about that one.

  • April 17, 2007 at 5:30 am

    #700887

     

     

    You CAN drop indexes anytime. But if you are planning on creating or re-building those indexes maybe you want to do during an off time period depending on your traffic.

  • April 23, 2007 at 1:29 pm

    #702007

    You should still be careful though ... dropping an index can have rather SEVERE performance impacts if it is one used frequently. Just imagine all of the lookups, index seeks, etc on an efficient index being changed into table scans against the actual data ... can you spell performance nightmare ?

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

Viewing 5 posts - 1 through 4 (of 4 total)

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