emdproduction_at_hotmail.com wrote:
> DA Morgan wrote:
>> emdproduction_at_hotmail.com wrote:
>>
>>> Thanks for your help
>> In Oracle, any time you say "ALWAYS," it is likely not correct.
>>
>> And most likely version specific too.
>> --
>> Daniel A. Morgan
>> University of Washington
>> damorgan_at_x.washington.edu
>> (replace x with u to respond)
>> Puget Sound Oracle Users Group
>> www.psoug.org
>
> It is Oracle 9207.
>
> And the most part I am interested in is, will Oracle be able to use
> remote index if we do not join remote table first, will Oracle really
> be bring all the data across the database link?
>
> Thanks for your help.
I'm not trying to be obtuse here but why don't you run an EXPLAIN PLAN
and find out?
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Sep 01 2006 - 13:09:47 CDT
