Re: rebuilding indexes - causes recompilation?

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

From: Roji. P. Thomas (lazydragon_at_nowhere.com)
Date: 09/02/04 

Date: Thu, 2 Sep 2004 14:14:17 +0530

http://support.microsoft.com/default.aspx?kbid=243586 

-- 
Roji. P. Thomas
Net Asset Management
https://www.netassetmanagement.com
"JB" <anonymous@discussions.microsoft.com> wrote in message
news:49b301c490c6$4b7798f0$a501280a@phx.gbl...
> 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)
  • Temporary vs Persistent tables
    ... breaking a stored procedure with ... >recompilation takes place on smaller units is helpful. ... >more helpful than temporary tables for a particular query ... >or stored procedure. ...
    (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)