Subject Re: [firebird-support] stored procedures
Author Ann W. Harrison
At 07:16 AM 9/8/2004, kaczy27 wrote:

>I have stored procedure that calls another stored procedure,
>while performing query to avoid multiple joining


>I can rewrite the stored procedure to use single select that will
>have three streamed joins will it be faster?


>the sp provide a subset depending on the parameter
>will it be faster executing if I create a view that will cover all
>records and 'where' it? The result is used in subsequent queries
>like above.

Probably not.