A PL/SQL performance question
From: Jambo <jshubo_at_yahoo.com>
Date: 5 Aug 2002 21:54:10 -0700
Message-ID: <cd48a5b6.0208052054.478d2e22_at_posting.google.com>
Date: 5 Aug 2002 21:54:10 -0700
Message-ID: <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
(2) second approach, compile Procedure_example in B using
BEGIN
select .......from table_B_at_db_link_B;
END
and then execute Procedure_example in A;
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 - 06:54:10 CEST