Dmitry, you support my point above. That potentially MASSIVE Cartesian product in the in-line view must suggest that the query is ill-conceived in the first place. So don't tinker with it - RETHINK IT.