Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!c13g2000cwb.googlegroups.com!not-for-mail
From: jdevroberto@yahoo.com
Newsgroups: comp.databases.oracle.server
Subject: Re: Performance in a view
Date: 12 Dec 2004 12:58:31 -0800
Organization: http://groups.google.com
Lines: 16
Message-ID: <1102885111.751950.242430@c13g2000cwb.googlegroups.com>
References: <9a9277b9.0412110704.6be5de8f@posting.google.com>
   <1102805682.639612.142320@z14g2000cwz.googlegroups.com>
   <1102836553.074510.233770@z14g2000cwz.googlegroups.com>
   <41bbfc1a$0$1084$afc38c87@news.optusnet.com.au>
   <1102880849.210982.277540@f14g2000cwb.googlegroups.com>
   <41bca5a7$0$6544$afc38c87@news.optusnet.com.au>
NNTP-Posting-Host: 206.221.195.105
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1102885115 11321 127.0.0.1 (12 Dec 2004 20:58:35 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Sun, 12 Dec 2004 20:58:35 +0000 (UTC)
In-Reply-To: <41bca5a7$0$6544$afc38c87@news.optusnet.com.au>
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: c13g2000cwb.googlegroups.com; posting-host=206.221.195.105;
   posting-account=_WUPnQ0AAAC9IJiser7nseazfpTwNUwN
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:231415

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