SQL Server Performance


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
  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