关于Natively Compiled Stored Procedures的优化金沙官网线

Parameter sniffing is not used for compiling natively compiled stored procedures. All parameters to the stored procedure are

Interpreted Transact-SQL stored procedures are compiled at first execution, in contrast to natively compiled stored procedures,

 

Natively Compiled Stored Procedures在创建时编译,所有参数都视为UNKNOWN值,因此很有可能会生成比较中庸的执行计划。可视情况考虑

supplied for this invocation are used by the optimizer when generating the execution plan.This use of parameters during

使用OPTIMIZE FOR hint来优化。

参考链接:

https://msdn.microsoft.com/en-us/library/dn205319.aspx

the OPTIMIZE FOR hint.

which are compiled at create time. When interpreted stored procedures are compiled at invocation, the values of the parameters

本文链接:http://www.cnblogs.com/ajiangg/p/6438556.html

considered to have UNKNOWN values.Like interpreted stored procedures, natively compiled stored procedures also support


compilation is called parameter sniffing.

本文由金沙官网线上发布于数据库,转载请注明出处:关于Natively Compiled Stored Procedures的优化金沙官网线

您可能还会对下面的文章感兴趣: