Re: Are there disadvantages of views.

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 22 Nov 1998 00:04:12 GMT
Message-ID: <36693086.5602710@netnews.worldnet.att.net>

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 21 1998 - 18:04:12 CST