What's wrong with this query?

LaercioCoelho 2013-09-06 22:08:42

Dan Holmes 2013-09-07 14:06:32
The sequence project node (7 from left) indicates at least more than one database is involved. I don't know much about how the optimizer works in that situation. In addition to that this is an estimated plan. That makes diagnosing any problem very difficult. can you provide an actual plan?
SQLkiwi 2013-09-18 09:38:58
> What's wrong with this query?

Probably very many things.

The estimates are probably way off, meaning the optimizer's chosen strategy is based on garbage information. You are also probably trying to do far too much in a single query.

The lack of runtime information and the nature of anonymized plans means it is hard to say much more than that.