From: Jerry Gitomer Subject: Re: Is using views always slower than using base tables? Date: 2000/07/07 Message-ID: <20000707.5320500@p200.nodomain>#1/1 Content-Transfer-Encoding: quoted-printable References: <8k2p93$eqv$1@nnrp1.deja.com> X-Priority: 3 (Normal) Content-Type: text/plain; charsetISO-8859-1 X-Complaints-To: abuse@rcn.com X-Trace: y/Mkj8eInvTJ1KbOytuUl/aaV5KivPK1nrtzcUMQSyw Mime-Version: 1.0 NNTP-Posting-Date: 7 Jul 2000 04:28:02 GMT Newsgroups: comp.databases.oracle.server I would think that in an OLTP environment views might be faster since they have already been parsed and are stored in the database. In an OLAP environment it probably won't make any difference since execution time far outweighs parse time. >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 7/6/00, 3:13:33 PM, yong321@yahoo.com wrote regarding Is using views always slower than using base tables?: > Is using views always slower than using base tables, at least > theoretically? My developers ask me to create views for them. I told > them views are used for two purposes: for convenience so that you don't > have to remember or type in all the base tables and their column names; > for security so as to hide some column or table names. My developers > are not end users. They don't need the convenience and they should be > allowed full select privilege on base tables. For performance reason, > views are always slower than or indistinguishably the same as using > base tables. Is this correct? > Yong Huang > yong321@yahoo.com > Sent via Deja.com http://www.deja.com/ > Before you buy.