Subject | Re: [IBO] Re: Using a View in IB_Query.SQL |
---|---|
Author | Helen Borrie |
Post date | 2002-10-16T23:29:27Z |
At 10:18 PM 16-10-02 +0000, you wrote:
The advantage of views is usually the security benefit, where a user's
access to certain columns of a table needs to be limited. GRANTs can be
made to the view without compromising the security of the whole table.
One recognised disadvantage of views is that their implementation in the
engine has never been free of a number of bugs. For sets involving
multiple complex joins - particularly between tables and views or between
one view and another - they should certainly be tested thoroughly to make
certain they generate the sets you expect.
Helen
>--- In IBObjects@y..., "Martin D. Berezaga" <mdberezaga@y...> wrote:All queries have to be prepared.
> > Is there any vantage/disvantage on using a View instead the Join
>that forms
> > the View? I'm using my own Edit/Inser/Delete SQL (Stored
>Procedures).
>
> >From what I understand...
>
>Advantages:
>1) Views don't have to be prepared. So technically they are faster
>(initially).
>Disadvantages:The same is true of joined datasets.
>2) Views are not updateable in certain instances.
>But these are client-side issues... if all this is done within SPs,Martin already said he was using custom xxxSQL.
>then there would be no difference.
The advantage of views is usually the security benefit, where a user's
access to certain columns of a table needs to be limited. GRANTs can be
made to the view without compromising the security of the whole table.
One recognised disadvantage of views is that their implementation in the
engine has never been free of a number of bugs. For sets involving
multiple complex joins - particularly between tables and views or between
one view and another - they should certainly be tested thoroughly to make
certain they generate the sets you expect.
Helen