rebuilding indexes - causes recompilation?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: JB (anonymous_at_discussions.microsoft.com)
Date: 09/02/04 

Date: Thu, 2 Sep 2004 01:24:41 -0700

Can anyone tell me if rebuilding an index causes
recompilation of a stored procedure the next time it is
run, or do I need to amnually run sp_recompile?

Also, how about adding a column to a table - does that
cause recompilation?

TIA,

JB

Relevant Pages

  • RE: Compiling Stored procedures
    ... Thank you for using the newsgroup. ... stored procedure (using WITH RECOMPILATION option). ...
    (microsoft.public.sqlserver.programming)
  • Re: Query Plan Differences
    ... HOW TO: Identify the Cause of Recompilation in an SP:Recompile Event ... INF: Troubleshooting Stored Procedure Recompilation ... "Yolanda" wrote in message ... > Does anyone know why a stored procedured executed in Query> Analyzer would generate a different execution plan as> opposed to when it's executed from within the VB Code? ...
    (microsoft.public.sqlserver.programming)
  • Re: Update from a form based on a one to many relationship
    ... Your form can be updateable even if the underlying stored procedure has a ... (and remove it the next time you want a full recompilation); ... >I have a form bound to a stored procedure with a 1-many ... > check boxes in SQL Server. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: rebuilding indexes - causes recompilation?
    ... Net Asset Management ... > Can anyone tell me if rebuilding an index causes ... > recompilation of a stored procedure the next time it is ...
    (microsoft.public.sqlserver.programming)
  • Re: Whats wrong with this picture?
    ... TIME the stored procedure ran after that it would be inefficient. ... > Tibor's answer most definitely doesn't validate the consultant - in fact ... recompilation. ...
    (microsoft.public.sqlserver.server)