Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Stored Procedure Vs. Views
- Thread starter c8ltgkue
- Start date
Hi,
In general a well-designed view ( which is just a query saved in the data dictionary) may perform as well as a SP for anything that standard SQL can do...There are things, however, that, if trying to use a standard query, would be difficult to make efficient ( or even possible, like testing the returned values from a subquery and constructing a 'where' clause based on those results).
As others have stated here, testing is much better than theory, so try both to see which works best in a given situation.
![[profile]](/data/assets/smilies/profile.gif "[profile] [profile]")
To Paraphrase:"The Help you get is proportional to the Help you give.."
In general a well-designed view ( which is just a query saved in the data dictionary) may perform as well as a SP for anything that standard SQL can do...There are things, however, that, if trying to use a standard query, would be difficult to make efficient ( or even possible, like testing the returned values from a subquery and constructing a 'where' clause based on those results).
As others have stated here, testing is much better than theory, so try both to see which works best in a given situation.
To Paraphrase:"The Help you get is proportional to the Help you give.."
- Status
Similar threads
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question