Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: cursor result return

Re: cursor result return

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Tue, 22 Feb 2005 20:27:45 +0100
Message-ID: <cvg0vh$sir$2@news2.zwoll1.ov.home.nl>


zibinyang_at_gmail.com wrote:
> 9 seconds is normal, becaues I am query a view, this view are link to 3
> remote tables.
>

Create the view on the remote site. You are probably pulling over the network the better part of 3 tables, where a view will be much smaller.

-- 
Regards,
Frank van Bortel
Received on Tue Feb 22 2005 - 13:27:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US