Is it faster to use a Stored Proc that returns a Type or has Out Parameters then a View? Views are easier to maintain I feel. I remember testing this around 8.0 days and the view seemed slower with a lot of data.
- [PERFORM] View vs Stored Proc Performance Jason Tesser
- Re: [PERFORM] View vs Stored Proc Performance Merlin Moncure
- Re: [PERFORM] View vs Stored Proc Performance Jason Tesser
- Re: [PERFORM] View vs Stored Proc Performanc... Merlin Moncure
- Re: [PERFORM] View vs Stored Proc Perfor... Jason Tesser
- Re: [PERFORM] View vs Stored Proc P... Merlin Moncure
- Re: [PERFORM] View vs Stored Pr... Dimitri Fontaine
- Re: [PERFORM] View vs Store... Merlin Moncure
- Re: [PERFORM] View vs Store... Ivan Voras
- Re: [PERFORM] View vs Store... Tom Lane
- Re: [PERFORM] View vs Store... Ivan Voras