Thomas Martin (9/12/2008)
What would cause this kind of behavior?
Has anything changed? Any index creates/drops? Any database settings changed?
It could be data volumes. The amount of data's increased and now the optimiser's picked a different plan. It could be index fragmentation. It could be inaccurate statistics
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