| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| 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 wrote:
>
> 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.
Views store just the text associated with them (not any data) thus there is no overhead when rows are added/removed etc from the table(s) in the view.
--
"Some days you're the pigeon, and some days you're the statue." Received on Thu Dec 09 1999 - 03:39:33 CST
 |
 |