Re: help: can we cache table from remote site?

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Thu, 21 Feb 2002 00:54:33 GMT
Message-ID: <3C74455C.10F2D4BC@ci.seattle.wa.us>

I am not aware of any method. but how often do these small tables change? Consider using DBMS_JOB or a materialized view to capture their contents every ten minutes or every hour.

Daniel Morgan

Mike F wrote:

> One of our most executed query use nested loop with a local large table
> and several small tables from the remote site using db_link, it is
> possible for us to cache the remote tables?
>
> Thanks for your help
Received on Wed Feb 20 2002 - 18:54:33 CST