Why might you create a stored procedure with the with recompile option?
- 1 Answers
- 1227 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
how to insert/update a csv file by comparing it with another csv file?
Where $mpjret is used in ab-initio?
We have file having country_name customer_name.For exp London Ram Bangalore Rohit London Shyam Bangalore Abhinav In output we need 2 files one file for london and second file for Bangalore.How to acheve this?
What is $mpjret? Where it is used in ab-initio?
What do you understand by a cartesian join?
Describe the process steps you would perform when defragmenting a data table. Does this table contain mission-critical data?
Mention what the difference between “look-up” file and “look is up” in abinitio?
How do you truncate a table?
What is brodcasting and replicate?
Which Ab initio version has Hadoop connector ? and what is the latest GDE version available ?
Explain what is de-partition in abinitio?
Do we really work with ACTUALDATA in development phase.
Teradata 
