Re: A PL/SQL performance question

2nd aproach is better. There are restrictions on what kind of data can be pulled over a db link. Not to mention the added network traffic.

jshubo_at_yahoo.com (Jambo) wrote in message news:<cd48a5b6.0208052054.478d2e22_at_posting.google.com>...
> Database A can access B via database link db_link_B
>
> I want to access table table_B in B by using some PL/SQL Procedure_example.
>
> (1) first approach, compile Procedure_example in A using
>
> BEGIN
> select .......from table_B_at_db_link_B;
> END
>
> and then execute Procedure_example in A;
>
> (2) second approach, compile Procedure_example in B using
>
> BEGIN
> select .........from table_B;
> END
>
> and then execute Procedure_example_at_db_link_B in A;
>
>
> Can anyone compare this two approach in term of system performance?
Received on Tue Aug 06 2002 - 22:30:37 CEST