Indexes Clarification

  • [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?

  • 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
  • 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) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

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

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