If we get an actual execution plan for a query and the estimated versus actual rows vary by a factor of 10 indicates the optimizer is using an outdated statistics. ANd an indication that stats need to be updated if query is slow.
links: extract from SQL Server 2008 query performance tuning distilled - Grant fritchey and Sajal Dam
No comments:
Post a Comment