![]() This article uses a simple example to illustrate the difference between the two (the test environment is SQL SERVER2014). ![]() Here comes another question: the Parameter embedding optimization (how to translate?) There is no Chinese reference to the Parameter embedding optimization, reluctantly translated as "parametric implant optimization") In fact, in some specific cases, the difference between the two is not just the difference between stored procedure-level recompilation and statement-level recompilation,įrom the execution plan generated by the compilation, the intrinsic mechanism differences between the two methods of forced compilation are still relatively large. It is relatively shallow to understand that the former is to compile all the statements in the entire stored procedure, the latter is to recompile a stored procedure in one of the statements, and did not investigate whether there is only such a little difference. ![]() One is based on the stored procedure level recompilation with RECOMPILE, and the other is option (RECOMPILE)-based statement-level recompilation. There are two ways to implement forced recompilation when considering recompiling T-SQL (or stored procedures), if you ignore other factors that cause recompilation, such as rebuilding indexes, updating statistics, and so on.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |