Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Impact of views on performances
Hi Michel,
AFAIK, views have no - to very insignificant impact on performance. The way it works ist that the view predicate and your query predicate is merged. An execution plan ist picked based on the resulting query.
So, it depends on the actual query+view whether a given index will be used. If it makes sense to the optimiser, it will.
Karsten
In article <38a24a55_at_news.vo.lu>,
"michel parisse" <michel.parisse_at_advalvas.be> wrote:
> I want to use views to isolate code from changes of my database
schema; Yet
> I am told that views will have a negative impact on performance with
the
> growing size of my database (today with the largest table at 150000
records,
> but growing). Further, when I have index defined on the tables that
I am
> planning to access through views, will these indexes continue to be
used?
>
> Any idea of impact or where to look for in depth information?
>
> Michel & Véronique Parisse
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Feb 10 2000 - 06:47:48 CST