SET NOCOUNT ON gives a performance boost to action queries by suppressing the "(n row(s) affected) message that results from running a query.
Qualifying an object with it's owner boosts performance because SQL does not have to work out where if there is a user specific version of the same object. It also gives benefits in the caching of execution plans.
The performance boost is due to the few bytes of information that make up the "(1 row(s) affected)" message not being transmitted to the client application.
No comments:
Post a Comment