Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Performance in a view
Thanks HJR,
For those of you who are entertainment challenged this weekend, I have posted the following in the hopes of more useful comments:
The query and its Execution Plan:
http://www.geocities.com/jdevroberto/p1211qryOut.txt
The view which wraps the above query and its Execution Plan: http://www.geocities.com/jdevroberto/p1211viewOut.txt
What looks interesting to me is the keyword, "CARTESIAN" in the second Plan.
-jd Received on Sun Dec 12 2004 - 14:58:31 CST