-
Stored Procedures
How does the stored procedures actully help in solving the query faster?
I know that Stored procedure execution plans can be reused, staying cached in SQL Server's memory, reducing server overhead.
But how to check it using Query analyzer using execution plan? I want to practically see the difference.
When we fire a single query on the database it gets cached then what's the difference?
Thanks in advance,
Prasanna.
-
If you are using the query only once, then there is not much gain. Stored procedures value becomes evident if the query is reused by many users.
-
Another point is
SQL Server 7.0 and 2000 can also catch the execution plans of Transact-SQL not in stored procedures.
Thanks a lot.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|