Re: How are joins performed when using a database link?

DA Morgan wrote:
>
> Rob Cowell wrote:
>
> > <snipped>
> >
> >
> > > it often happens here that guys spend more time typing out a request
> > > for advice than actually having a go, making a few mistakes & testing
> > > things out.
> >
> > I think you are being a bit harsh on this poster.
>
> You are correct with respect to how it works. But incorrect with respect to the
> basic premise which is the impact on performance.
>
> In less time than it took to post the request and wait for a response the OP
> could have run a test. And while not knowing "how it worked" would sure know
> the relative performance on THEIR system.
>
> Daniel Morgan

So he would have known what improved performance on this particular query on this system but not why, or how to find out why. He would have been back to square one with the next problem of this type, and in no position to think about how to solve a more complex distributed problem.

I appreciate there are a lot of people who don't seem to be able to find a freely available manual but I don't think this topic is particularly well explained anywhere obvious.

Let's face it most problems here can be solved if you want to plow through Metalink and make some empirical discoveries. Received on Mon Mar 17 2003 - 11:09:18 CST