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) A socialist is someone who will give you the shirt off *someone else's* back.
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