Query longer in SP

hi every one,
I have a stored procedure that run about 10 "select"
and "select into" queries.
Some of them run longer into the SP(10 sec) than outside
the SP (1 sec).
Me question is : why ?
Thanks !!!
Don
Check the execution plans between the 2. Do you pass in parameters? Here's
a good link on parameter sniffing.
http://groups.google.com/groups?q=%2...FTNGP09&rnum=1
hth
Eric
Donald wrote:
> hi every one,
> I have a stored procedure that run about 10 "select"
> and "select into" queries.
> Some of them run longer into the SP(10 sec) than outside
> the SP (1 sec).
> Me question is : why ?
> Thanks !!!
> Don
|||thanks !
It works, Using local variable + exec(@.mysql)
Don
>--Original Message--
>Check the execution plans between the 2. Do you pass in
parameters? Here's
>a good link on parameter sniffing.
>http://groups.google.com/groups?q=%22what+is%22%2B%
22parameter+sniffing%22&hl=en&lr=&ie=UTF-
8&selm=etMEpxNsCHA.2648%40TK2MSFTNGP09&rnum=1
>
>hth
>Eric
>
>
>Donald wrote:
>
>.
>