Re: cost

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Mon, 05 Apr 2004 18:48:21 -0600
Message-Id: <6.0.3.0.2.20040405184620.02d20a30@pop.centrexcc.com>

I get the same result (higher cost hash join chosen over NL join) with Oracle 8.1.7.4.1

At 01:28 PM 4/5/2004, you wrote:

>My guess would be that this is a deliberate
>heuristic introduced some time around 9
>to avoid nested loop full tablescans when
>the numbers are small.

Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Apr 05 2004 - 19:45:15 CDT