关于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来优化。
the OPTIMIZE FOR hint.
which are compiled at create time. When interpreted stored procedures are compiled at invocation, the values of the parameters
considered to have UNKNOWN values.Like interpreted stored procedures, natively compiled stored procedures also support
compilation is called parameter sniffing.