At 04:56 PM 1/1/2003 -0400, Daniel Rail wrote:

> > unique to IB/FB only. Is the 'recommendation' above still
> > correct,
> > in the sense that Selectable SPs are the recommended way in
> > IB/FB
> > to create 'server side queries' ?
>
>SPs are precompiled and Views are prepared each time you use them.

That has plusses and minuses. Because the stored procedure is
compiled as a unit, no optimization is available between the
tables it references and any join terms. Thus a view may give
better performance.


Regards,

Ann
www.ibphoenix.com
We have answers.