|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,Why?
>while performing query to avoid multiple joining
>I can rewrite the stored procedure to use single select that willProbably.
>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