1. contactjimmyus Member

   I want to know the relation ship between recompilation and indexes
   Does any index forces for any recompilation of the procedure
   Thanks
   

   contactjimmyus, Apr 3, 2011

   #2
2. satya Moderator

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

   satya, Apr 4, 2011

   #3

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in