Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Andy Warren Dynamic SQL or Stored Procedure RE: Dynamic SQL or Stored Procedure
RRadcliff3
SSCommitted
Points: 1667
More actions
April 21, 2003 at 8:04 am
#454771
quote:what are the benefits of a compiled query plan?
quote:
Faster execution. With a compiled query plan, SQL doesn't have to figure out the best way to execute the code, it reuses an old plan.