SQL Server Performance

Recompilation

Discussion in 'SQL Server 2005 T-SQL Performance Tuning' started by contactjimmyus, Apr 3, 2011.

  1. I want to know the relation ship between recompilation and indexes
    Does any index forces for any recompilation of the procedure
    Thanks
  2. satya Moderator

    Not directly but the REINDEX will compile the statistics which causes a recompile on first execution of SP after that reindex.

Share This Page