Processing in db_link

From: Aldi Barco <ipal_at_hotmail.com>
Date: Fri, 15 Sep 2000 23:21:53 JAVT
Message-Id: <10620.117135@fatcity.com>

Hi......

I have a question about performance in database link.

Where is query processing (parse,execute,etc) take place in the queries below that using database link ? In local or in remote server ?

The queries :

1. select * from emp_at_remote1 where ename like 'SCOTT' and dept = (....another subquery here for remote table)
2. select ename from emp_at_remote1 e1, emp e2 where e1.ename = e2.ename.

My options are : processing query in remote and then transmit OR querying using dblink.

Thanks for any clue.

Aldi
Oracle DBA

---

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at Received on Wed Dec 31 1969 - 17:59:59 CST