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

Why?

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

Probably.

>secondary
>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.

Regards,


Ann