Re: SQL: View performance problem

I would guess that you have got a correlated subquery taking place which is (by default) being postponed to the end of the plan. If this is the case (check with explain plan), then you may be able to use the PUSH_SUBQ hint to make the subquery run at the earliest possible point in the query.

---
Jonathan Lewis.