Subject SP VS View
Author Indysoft Bt.
Hi Friends!

I'd like to know what is a better choice in general, selectable SP or
VIEW? I didn't experienced any performance drawbacks when using SPs
instead of views, but what is your opinion? I even noticed better plan
were used for procedures, than views. I would prefer SPs, because of the
recompiling issue of views when there are dependencies. With SPs this go
away and they can be compiled whenever I want.

TIA:Alex :-)