Post reply

Creating indexes on all field of a table

  • June 15, 2011 at 3:46 am

    #145567

    What are the drawback of creating indexes on all Columns of a table ?

  • June 15, 2011 at 4:24 am

    #1338854

    In short - performance. Indexes help SQL retrieve data but slow down the inserts/updates of the data. It's too broad a question to give any more of a meaningful answer - please post an example of the data and we can perhaps provide some useful information.

  • June 15, 2011 at 4:33 am

    #1338859

    Massive waste of space, increase in maintenance time, increase in insert, update, delete. Unless you have queries that do single-column filters on the columns they're unlikely to be used.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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