Re: How to improve queries remotely

From: Charles Hart <cchart3_ol_at_hotmail.com>
Date: Wed, 05 Mar 2003 14:33:20 -0800
Message-ID: <F001.00561844.20030305143320@fatcity.com>

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" <david.m.nguyen_at_xo.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>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 link?
>
>
>
>Regards,
>David
>

---

The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Charles Hart
  INET: cchart3_ol_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Mar 05 2003 - 16:33:20 CST