Re: Performance of queries with DB_LINKS

NetComrade wrote:
>
> Hi,
>
> i know the db_links are generally a big performance killer, but if all
> dbs are on the same LAN and there isn't THAT much activity through
> them, are they still going to be a prob?
>
> Thanx.

joins across db links can be a problem since under certain conditions the table(s) must be shipped to/from the remote node to allow the join..

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse