Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Is there any overhead using views

Re: Is there any overhead using views

From: Lee Kyoung Rok <tunnel_at_hananet.net>
Date: Fri, 10 Dec 1999 02:02:34 +0900
Message-ID: <3iR34.2678$sI3.98721@news.hananet.net>

Hugh Pendry <hpendry_at_trinitech.co.uk>ÀÌ(°¡) ¾Æ·¡ ¸Þ½ÃÁö¸¦ news:82o2qd$ck4$1_at_trinitech.demon.co.uk¿¡ °Ô½ÃÇÏ¿´½À´Ï´Ù.
> I have created a view which massively speeds up a query,
> I would like to know if there is any overhead using views
> (perhaps when the record is added)
>
> The query that is speeded up is, selecting a record from a table
> using many foreign keys. To get the values for the keys (integer)
> I look up against a text field, some of these lookup tables are 'large'
> 10000+ records. All fields do not allow nulls.
>
> I don't understand why the view is quicker than the query (all the
> necessary indexes are in place), unless there is some sort of
> overhead when a record is added, in the same way that an index
> incurs an overhead when adding records, in order to maintain the
> index.
>
> Basically I don't understand how views work and so I can't evaluate the
> pros and cons of using them.
>
> Can anyone give me an explanation or a pointer to some information
>
> thanks a lot
> hugh.
>
>

View doesn't need parse time after first execution of SQL. Received on Thu Dec 09 1999 - 11:02:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US