Re: Are there disadvantages of views.

If the data is static, (ie datawarehouse or datamart type of application), and the view is going to be accessed frequently, you might want to consider creating a new table instead of the view....

for what it's worth

James

Jonathan Gennick wrote:
>
> On Thu, 19 Nov 1998 18:17:39 +0800, Terrence Wong
> <terrence_at_asiansources.com> wrote:
>
> >I am considering implementating a data view which could be VERY big. Are
> >there disadvantages in such implementation, I will be joining 2 to 4
> >tables to present a gigantic view.
>
> Disadvantages as opposed to what? If your choice is between
> implementing a query as a view, and implementing the same
> query as a SQL statement, then views present no
> disadvantages.
>
> On the other hand, if your tables are large, and your join
> complex, you could end up with a query that takes a long
> time to execute. But whether its a view or not won't affect
> this.
>
> Jonathan
Received on Sat Nov 28 1998 - 21:01:43 CST