Exceute As用户需要不同的时间来执行 [英] Exceute As User takes different time to execute

问题描述

Hello Everyone

Hello Everyone

我有一个使用"Execute AS"的SQL存储过程。每当被调用时子句。

I have a SQL stored procedure which uses "Execute AS" clause whenever called.

对于一个用户，sp在不到一分钟的时间内执行，但是使用另一个UserName，sp将永远执行。

With one user the sp executes in less than a minute but with another UserName the sp takes forever to execute.

什么可以是这个的原因。 sp调用看起来像

what could be the reason for this. The sp call looks like

exec as user ='[e-mail]'

exec as user = '[e-mail]'

exec< SP name> param1，param2 ......

exec <SP name> param1,param2......

谢谢

推荐答案

这篇关于Exceute As用户需要不同的时间来执行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！