Re: Oracle & Views

From: Ed Prochak <prochak_at_my-dejanews.com>
Date: Wed, 24 Mar 1999 19:25:08 GMT
Message-ID: <7dbe68$ld3$1@nnrp1.dejanews.com>

In article <Ff6K2.2061$Nm3.29158_at_news20.ispnews.com>, "Andrew Thomas" <athomas_at_iminformation.com> wrote:
> In the couple of books that I have, I'm having trouble locating much useful
> information about views. I'm wondering how much resource a view would take.
> Does it just create a 'filter' for the data? I have a table of 1.7 million
> rows and I'm wondering what affect it will have on the system if I create
> 200 views? Is there a better way to do this?
>
> Please respond via email to athomas_at_iminformation.com if at all possible.
>
> Thanks,
> -Andrew Thomas-
>
>

A view takes very little storage, essentially enough to stored the query that forms the view. You're right that it is basically a "filter". So the resources it takes are memory and CPU cycles when the view is actually used.

So creating 200 views isn't going to be a storage hog. But using a lot of those views at the same time "may" be a performance hog.

However, note the qualification. With well tuned queries, using indices and other sql performance enhancements, views can be very useful and powerful.

Good luck.

Ed Prochak
Magic Interface, Ltd.
ORACLE services
440-498-3702

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Mar 24 1999 - 13:25:08 CST