May 17, 2018 at 10:25 am
Your clustered index is fine.
Actually that's a significant understatement by me. Your clus index is generally superb (although you could probably remove the Attribute* columns with no real loss to performance.
Congrats for not blindly following the nursery-rhyme-like saying of "narrow, ever-increasing, blah blah blah". That's fine as a general rule, but experts know when to ignore general rules in favor of the best solution for a specific table. The "default" clustering on identity hurts overall db performance more than any other myth about performance.
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".
May 17, 2018 at 10:49 am
ScottPletcher - Thursday, May 17, 2018 10:25 AMYour clustered index is fine.
Actually that's a significant understatement by me. Your clus index is generally superb (although you could probably remove the Attribute* columns with no real loss to performance.Congrats for not blindly following the nursery-rhyme-like saying of "narrow, ever-increasing, blah blah blah". That's fine as a general rule, but experts know when to ignore general rules in favor of the best solution for a specific table. The "default" clustering on identity hurts overall db performance more than any other myth about performance.
Thank You. I really appreciate
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply