How does Oracle implement views?

From: <alacy_at_hayes.com>
Date: 13 Aug 93 18:25:11 EDT
Message-ID: <7781.2c6bdc87_at_hayes.com>


Does anyone know what Oracle does under the covers, when a view which uses more than one table (ie, join, or union and so on) is accessed? I think Oracle creates a temporary table in the temp tablespace, and once the select to the view is finished, the temporary table is deleted. Does anyone know if this is the case?

-- 
Allen Lacy, Principal Analyst | internet:  alacy_at_hayes.com              
(404) 840-9200 (x.2131)       | uucp:      uunet!hayes!alacy     
Hayes Microcomputer Products  | U.S.Mail:  p.o.box 105203, Atlanta, GA 30348
Received on Sat Aug 14 1993 - 00:25:11 CEST

Original text of this message