Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Is using views always slower than using base tables?
Views have proved to be slower in 8.0.6 when joining to base tables that
when used in 7.3.4. The execution plan from 7 -> 8 is way different.
<yong321_at_yahoo.com> wrote in message news:8k2p93$eqv$1_at_nnrp1.deja.com...
> 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_at_yahoo.com
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Jul 07 2000 - 00:00:00 CDT