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

sp:
select field
from t1 left join t2

sp2:
select field
from sp1 left join t3

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

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.

CUIN Kaczy