RE: Remote query puzzle

From: Spears, Brian <BSpears_at_Limitedbrands.com>
Date: Thu, 8 Sep 2005 16:16:36 -0400
Message-ID: <50938E6468CFED40AE0FD7A507D96D340207CE2F@EXCHSERV2.Limited.brands.com>

What about ... Forcing hash joins or setting up inline views!! And if have to ...setup in stored plan

bri

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mladen Gogala
Sent: Thursday, September 08, 2005 3:42 PM To: oracledba.williams_at_gmail.com
Cc: oracle-l
Subject: Re: Remote query puzzle

On 09/08/2005 02:09:00 PM, Dennis Williams wrote:
> Thanks Jared, Mark, Mladen, Ben

> Any thoughts on the best way to induce Oracle to join tables in a
> specific order would be appreciated. This is 8.1.7, rule-based.

I neglected the "rule based" part. It was a long, long time ago. As far as I remember, RBO will access table sorted by the rank, starting with the table that has the highest rank, which was usually the table being accessed by the full table scan or index range scan.
Ranks were integers, ranging from 0 (access by rowid) to 23 (full table scan). You could not influence that by the full table scan. How about analyzing the tables and putting hints in the view? That should force CBO just for this one view.

--
Mladen Gogala
http://www.mgogala.com


--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Sep 08 2005 - 15:19:36 CDT