Query takes too long to complete
2014-12-24 17:09:19
SQLkiwi 2014-12-25 05:35:35
Is it possible to provide a post-execution plan? Ideally with the statements run directly from Plan Explorer?
2014-12-30 16:52:17
link text
post execution plan uploaded.
thanks
2014-12-30 19:11:20
This plan wasn't generated by running the query from inside Plan Explorer, so it is missing a lot of key metrics like duration, reads, table I/O, etc. Any chance you could provide that?
2014-12-31 13:25:26
That plan still only has estimated numbers. Run the query from Plan Explorer, or at least turn "Actual Plan On" in SSMS and capture the plan from there.