Re: Is it always true to join remote table first?

From: <emdproduction_at_hotmail.com>
Date: 1 Sep 2006 11:01:18 -0700
Message-ID: <1157133678.600017.171610@b28g2000cwb.googlegroups.com>

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. Received on Fri Sep 01 2006 - 13:01:18 CDT