Post reply

SpBlitzIndex

  • June 14, 2015 at 10:14 pm

    #309106

    Hi All,

    I run spblitz against to a table. It is giving so many missing indexes and wide indexes?

    Do we need create all of those missing indexes?

  • June 15, 2015 at 1:59 am

    #1805391

    Probably not. Create the ones that are more likely to improve performance.

    -- Gianluca Sartori

  • June 15, 2015 at 2:04 am

    #1805393

    Yes You are not supposed to create all the indexes. if u create one then there lots of chances are few will become redundant. so analyse them and create one which will enhance the performance.

    If u create all then it surly burden u r database

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

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