[ Thanks to Jane Walker for this link.
]
“What’s the difference between a stored procedure and a
view, if both are pre-compiled objects? Which of the two is faster?
Doesn’t compiling make things quicker?“Mich Talebzadeh: On the face of it, one might
think that a view and a stored procedure were equivalent to one
another. After all, a view returns a result set, and a stored
procedure can also return one. But that’s where the similarity
ends…”