Message-Id: <10618.116847@fatcity.com>
From: Chuck Hamilton <chuck_hamilton@yahoo.com>
Date: Wed, 13 Sep 2000 09:14:52 -0700 (PDT)
Subject: Re: HASH_JOIN on RBO?

--0-317097467-968861692=:8405
Content-Type: text/plain; charset=us-ascii


 It referneces a view but the view has no hints. Not only is the query hinted to the rbo, but I checked the optimizer_goal in the init file and it's set to RULE also. I'm still scratching my head.

  MTPConsulting@aol.com wrote: 
Chuck,
Could you be referencing a view that uses a CBO hint? I've seen it happen 
where the query had a RULE hint, but used a view with a CBO hint and that 
caused the whole query to use CBO.

Marc Perkowitz
MTP Systems Consulting, Ltd.

In a message dated 9/12/00 8:36:24 PM Central Daylight Time, 
chuck_hamilton@yahoo.com writes:

<< I have a query with a RULE hint, but the execution plan is show hash 
joins. Is this something new in the 8.1.5 optimizer? It used to be that you 
could only get HASH joins with CBO. Also, each of the operations is showing a 
cost and cardinality even though none of the tables have stats. The net 
result is I'm getting a horrible execution plan that includes cartesian 
merges and runs for hours when previously this query ran in minutes. Any 
ideas? >>


---------------------------------
Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere!
--0-317097467-968861692=:8405
Content-Type: text/html; charset=us-ascii

<P> It referneces a view but the view has no hints. Not only is the query hinted to the rbo, but I checked the optimizer_goal in the init file and it's set to RULE also. I'm still scratching my head.<BR>
<P>&nbsp; <B><I>MTPConsulting@aol.com</I></B> wrote: <BR>
<BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px">Chuck,<BR>Could you be referencing a view that uses a CBO hint? I've seen it happen <BR>where the query had a RULE hint, but used a view with a CBO hint and that <BR>caused the whole query to use CBO.<BR><BR>Marc Perkowitz<BR>MTP Systems Consulting, Ltd.<BR><BR>In a message dated 9/12/00 8:36:24 PM Central Daylight Time, <BR>chuck_hamilton@yahoo.com writes:<BR><BR>&lt;&lt; I have a query with a RULE hint, but the execution plan is show hash <BR>joins. Is this something new in the 8.1.5 optimizer? It used to be that you <BR>could only get HASH joins with CBO. Also, each of the operations is showing a <BR>cost and cardinality even though none of the tables have stats. The net <BR>result is I'm getting a horrible execution plan that includes cartesian <BR>merges and runs for hours when previously this query ran in minutes. Any <BR>ideas? &gt;&gt;</BLOCKQUOTE><p><br><hr size=1><b>Do You Yahoo!?!
</b><br>
<a href="http://mail.yahoo.com/">Yahoo! Mail</a> - Free email you can access from anywhere!