Unfortunately, in the case I noticed this happen, the join needs to be
applied first since the filter's where clause and the order by both
depend on the joined tables. Don't think your solution is helpful in
that case, but informative nonetheless.
I can imagine a DISTINCT helping (I am using
Kent wrote:
Unfortunately, in the case I noticed this happen, the join needs to be
applied first since the filter's where clause and the order by both
depend on the joined tables. Don't think your solution is helpful in
that case, but informative nonetheless.
I can imagine a DISTINCT