Jayanth_Kurup (6/27/2011)
Is it worth the effort to identify table with high index fragmentation and then update stats for those tables more frequently instead of doing a full scan
I actually do both. Reindex only what needs to be worked on. Then update all stats with full scan (I can fit this in my window so I just do it).
Yes I know this causes an overlap on some stats because I do rebuilds on a couple indexes daily but since that's well under 0.1 of the indexes I don't care.
Never had a single parameter sniffing issue in the 6 months+ doing that.