June 22, 2005 07:22 PM
Reusing Query Plans
Learn how the optimizer works--and when plan reuse doesn’t work
Rating:
(3)
SQL Server Magazine
InstantDoc ID #46233
I've worked with SQL Server, in its Sybase and Microsoft incarnations, for almost 18 years. From the first, I've heard that one of the most important reasons for using stored procedures is that they're precompiled. But, as I mentioned last month in "Tracking Recompiles" (InstantDoc ID 46075), before SQL Server 7.0, the time savings you gained was often insignificant.
The pe...
...This article is for paid Professional Members only.
Already a Professional Member? Please log in now: