Re: inline views

[Daniel W. Fink]

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 ?

Thanks

 



--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Daniel W. Fink
 INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).