Stueyd (11/2/2012)
What's the tipping point where there's so few rows it's not worth it?
0.
Every table should have a clustered index unless you have a good reason otherwise (low row count is not a good reason)
but the reality is that there is a point below which a Clustered Index is more of an overhead than a help.
No, there isn't.
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