Interview Questions - When you create a stored procedure you provide an option with RECOMPILE What does this do??

Getting Started with Adobe After Effects - Part 6: Motion Blur


	Interview Questions

This module helps you to share, discuss and learn interview questions and answers of different technologies


	Submit a Question


	Subscribe..

Home · Most Liked · Most Asked · Most Discussed · Sections

When you create a stored procedure you provide an option with RECOMPILE What does this do??

May 28 2012 12:00AM by Manjunath C Bhat

Question

When you create a stored procedure you provide an option with RECOMPILE What does this do?

Answer

When ever you create a stored procedure, its compiled and the Query execution plan is stored in Cache. So when ever this stored procedure is used, SQL Server fetches this stored Query Execution plan from cache and executes.

So when you create procedure with Re-Compile option, when you execute this procedure, the procedure is compiled each time its run and new query plan is created for the same

Read More.. [32134 clicks]

Published under: SQL Server Interview Questions · · · ·

Previous: SQL SERVER- what are EXCEPT and INTERSECT?
Next: Temporary Table Life Span / Scope

Manjunath C Bhat

102 · 2% · 511

Liked

Asked


Post this to my facebook wall
Tweet this
Like this
I have asked or faced this question during an interview


	Submit

Your Comment

Sign Up or Login to post a comment.

"When you create a stored procedure you provide an option with RECOMPILE What does this do??" rated 5 out of 5 by 6 readers

When you create a stored procedure you provide an option with RECOMPILE What does this do??

Question

Answer

Your Comment