Re: Are there disadvantages of views.

Views only contain the SELECT statement itself, NOT the data. So views can, by definition, not become large.
Every time the view is used, the result set is being determined and delivered. There is no significant difference using a view to get data from 2 to 4 joined tables and using a plain sql statement which does the same.

Jac.

Terrence Wong wrote in message <3653F043.CEC5237_at_asiansources.com>...
>Hi,
>
>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.
>
>Any information could be useful.
>
>Thank You.
>Terrence
Received on Thu Nov 19 1998 - 15:09:55 CST