I have found in my testing that an inline view works just as well as a
normal view . If you are unsure, run explain plan and check the OTHER column
in the plan_table. It'll show what is being executed remotely.
Kevin
-Original Message-
Sent: Wednesday, March 05, 2003 5:40 PM
To: Multiple
David -
create table local as select * from [EMAIL PROTECTED] usually improves it.
:-)
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, March 05, 2003 3:55 PM
To: Multiple recipients of list ORACLE-L
What is a
One of the things that has helped me in the past is to set a view on the
remote database if I was joining two or more remote tables.
Another thing that has helped is to make a snapshot if the data is going to
be used often.
From: Nguyen, David M [EMAIL PROTECTED]
Reply-To: [EMAIL
I am not a fan of views, but build remote views to have has much
screening of data and processing done remotely before you return the
data.
--
Regards,
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Faroult
INET: [EMAIL
Limit the data you get across the network...
Take the query that gets sent across the db link (u can get it from the
explain plan or oem sql analyze) and runit on the remote db and check its
access path
Thanks a lot...
Babu