Re: Remote query puzzle
- From: Mladen Gogala <gogala@xxxxxxxxxxxxx>
- To: oracledba.williams@xxxxxxxxx
- Date: Thu, 08 Sep 2005 19:42:29 +0000
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
