赞
踩
如果语句单独执行很快,但是放到存储过程中很慢,那可能是执行计划搞的鬼试试
WITH RECOMPILE
关于存储过程级别的重编译,典型用法如下,在存储过程参数之后指定“WITH RECOMPILE”
- CREATE PROCEDURE Pro_Test
- (
- @id int
- )WITH RECOMPILE
- AS
- BEGIN
- SELECT * FROM Test WHERE fId = @id ;
- END
- GO
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。