Why might you create a stored procedure with the with recompile option?
- 1 Answers
- 1228 Views
- I also Faced
- E-Mail Answers
Answer Posted / Surya Mohan Sharma
Creating a stored procedure with the 'with recompile' option can be beneficial in situations where the procedure uses parameters that are dependent on the caller, and those parameters cause the procedure to reference different objects within the database. By using 'with recompile', the optimizer will generate a new execution plan for each call, taking into account the specific parameter values, rather than reusing an outdated plan.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to add default rules in transformer?
can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................
Hi friends, what are the new features in abinito3.0?
What is rollup component?
What is a rollup component? Explain about it.
