From: "Gary Healy (Powerup)" <ghealy@powerup.com.au>
Subject: Re: Is using views always slower than using base tables?
Date: 2000/07/07
Message-ID: <3965d4c1@grissom>#1/1
Distribution: world
References: <8k2p93$eqv$1@nnrp1.deja.com>
X-Original-NNTP-Posting-Host: ts53036.powerup.com.au
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
X-Trace: ozemail.com.au 962974914 203.32.8.130 (Fri, 07 Jul 2000 23:01:54 EST)
Organization: OzEmail Ltd, Australia
X-MSMail-Priority: Normal
NNTP-Posting-Date: Fri, 07 Jul 2000 23:01:54 EST
Newsgroups: comp.databases.oracle.server


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@yahoo.com> wrote in message news:8k2p93$eqv$1@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@yahoo.com
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.