Subject Re: Using a View in IB_Query.SQL
Author Eric Handbury
--- In IBObjects@y..., "Martin D. Berezaga" <mdberezaga@y...> wrote:
> 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:
2) Views are not updateable in certain instances.

But these are client-side issues... if all this is done within SPs,
then there would be no difference.