RE: inline views

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Wed, 16 Jul 2003 16:23:17 +0530
Message-Id: <25937.337992@fatcity.com>

Daniel, List

Can you give more detail with an EXAMPLE please ?

Thanks

-----Original Message-----
From: Daniel W. Fink [mailto:optimaldba_at_yahoo.com] Sent: Friday, June 06, 2003 7:05 PM
To: Multiple recipients of list ORACLE-L Subject: Re: inline views

I have used an inline view to reduce network traffic when retrieiving data from a remote db. Instead of using a nested loop and making multiple trips, it made 1 trip and brought over all of the data. The query time was reduced from 30 minutes to 5 minutes.

-- 
Daniel W. Fink
http://www.optimaldba.com


VIVEK_SHARMA wrote:



>Where are they advantageous to use & where not ?

Received on Wed Jul 16 2003 - 05:53:17 CDT