Database performance is determined by several factors and query performance is one of them. SQL performance measures the time it takes to perform a required function and if outcome expectations are met. Improving SQL query performance will have a significant impact on the performance of your database and these are tips any IT consulting service expert would recommend to improve SQL query performance.
Using stored procedure for a complex or frequently used query is thus another way of improving your SQL query performance.
« 6 Ways to Improve Your Database Performance