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
Subject: How to improve queries
remotely
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 PRO
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: How to improve queries remotely
Date: Wed, 05 Mar 2003 13:54:45 -0800
What is a guideline to improve remotely query using database l
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 guidel
What is a guideline to improve remotely query using database
link?
Regards,
David
