I have a query which takes a very long time to complete appx 1 hour. If I run an estimated execution plan on the query, this can run for over an hour and doesn't return the plan. Any ideas why the plan should take so long. Is the only way around this
to clear the cache?
View Complete Post