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: Oracle & Views

Re: Oracle & Views

From: Vitaliy Mogilevskiy <vit100gain_at_earthlink.net>
Date: Wed, 24 Mar 1999 10:47:58 -0800
Message-ID: <36F9335E.C809E94E@earthlink.net>


Views are GOOD, they are stored select's on the server side Use them !

Vitaliy Mogilevskiy

Andrew Thomas 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-
Received on Wed Mar 24 1999 - 12:47:58 CST

Original text of this message

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