Post reply

Indexes Clarification

  • September 12, 2012 at 2:50 pm

    #266560

    [p]

    Higly transactional table should not have Clustered Indexes

    Highly transaction table should not have Fill Factor in index definition

    [/p]

    What does the above statements really mean? Does that mean that tables where there is huge amount of write operations should not have Clustered Indexes and Indexes should not have any fill factor?

  • September 12, 2012 at 3:51 pm

    #1536940

    Well, both of those statements are incorrect, so probably better to just ignore them...

    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

  • September 12, 2012 at 4:27 pm

    #1536949

    GilaMonster (9/12/2012)

    Well, both of those statements are incorrect, so probably better to just ignore them...

    Quite true.

    SQL DBA,SQL Server MVP(07, 08, 09) "Money can't buy you happiness." Maybe so, but it can make your unhappiness a LOT more comfortable!

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

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