Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Is there any overhead using views
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