HASH_JOIN on RBO?

From: Chuck Hamilton <chuck_hamilton_at_yahoo.com>
Date: Tue, 12 Sep 2000 13:27:36 -0700 (PDT)
Message-Id: <10617.116761@fatcity.com>

--0-1973594324-968790456=:11682

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

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-1973594324-968790456=:11682

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

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&nbsp;a horrible execution plan that includes cartesian merges and runs for hours when previously this query ran in minutes. Any ideas?<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!
--0-1973594324-968790456=:11682--
Received on Tue Sep 12 2000 - 15:27:36 CDT