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>
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 30348Received on Sat Aug 14 1993 - 00:25:11 CEST