RE: HASH_JOIN on RBO?

From: Chuck Hamilton <chuck_hamilton_at_yahoo.com>
Date: Wed, 20 Sep 2000 05:43:37 -0700 (PDT)
Message-Id: <10625.117432@fatcity.com>

--0-491705403-969453817=:16214

Content-Type: multipart/alternative; boundary="0-1918502651-969453817=:16214"

--0-1918502651-969453817=:16214

Content-Type: text/plain; charset=us-ascii

 here are the attachments you wanted (why_cost.prf and why_cost.lst)

  Steve Adams <steve.adams_at_ixora.com.au> wrote: Hi Chuck,

In that case, either one of the other pieces of information that you've given us is incorrect, or this is a bug. Could you please try it as follows

spool why_cost
set long 1000
column text format a80 word
select text from dba_views where view_name = 'PS_QVC_PERS_SRCH_VW'; alter session set events '10053 trace name context forever'; alter session set sql_trace = true;
set autotrace traceonly explain
SELECT --+ RULE
...
spool off
exit

Please note the extra space before the hint comment to force a reparse. If you need to do it more than once, insert one more space each time, or flush the shared pool first. Please post the spool file and the trace file.

---

Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
--0-1918502651-969453817=:16214

Content-Type: text/html; charset=us-ascii

<P> here are the attachments you wanted (why_cost.prf and why_cost.lst)<BR></P>
<P>&nbsp; <B><I>Steve Adams &lt;steve.adams_at_ixora.com.au&gt;</I></B> wrote: <BR>
<BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px">Hi Chuck,<BR><BR>In that case, either one of the other pieces of information that you've given us<BR>is incorrect, or this is a bug. Could you please try it as follows<BR><BR>spool why_cost<BR>set long 1000<BR>column text format a80 word<BR>select text from dba_views where view_name = 'PS_QVC_PERS_SRCH_VW';<BR>alter session set events '10053 trace name context forever';<BR>alter session set sql_trace = true;<BR>set autotrace traceonly explain<BR>SELECT --+ RULE<BR>...<BR>spool off<BR>exit<BR><BR>Please note the extra space before the hint comment to force a reparse. If you<BR>need to do it more than once, insert one more space each time, or flush the<BR>shared pool first. Please post the spool file and the trace file.<BR><BR></BLOCKQUOTE><p><br><hr size=1><b>Do You Yahoo!?</b><br>

Send instant messages & get email alerts with Yahoo! Messenger.
--0-1918502651-969453817=:16214--
--0-491705403-969453817=:16214

Content-Type: text/plain; name="why_cost.txt"
Content-Transfer-Encoding: 8bit
Content-Description: why_cost.txt
Content-Disposition: attachment; filename="why_cost.txt"

<binary content removed -- do not send attachments to the list> Received on Wed Sep 20 2000 - 07:43:37 CDT