Why do Ado.net don't use execution plan that Query Analyzer

17 Mar 2006 1:45 AM

David Dong

Hi All,

I would be grateful if you can give me some directions.

Thanks.
Best Regards,
David

17 Mar 2006 1:54 AM

David Dong

Hi All,

The question is:
Why do Ado.net don't use execution plan that Query Analyzer generate?

I would be grateful if you can give me some directions.

Best Regards,
David

Show quoteHide quote

"David Dong" <dongxiao***@hotmail.com> wrote in message
news:O27lpRWSGHA.736@TK2MSFTNGP12.phx.gbl...
>
>
> Hi All,
>
> I would be grateful if you can give me some directions.
>
> Thanks.
> Best Regards,
> David
>

17 Mar 2006 5:12 AM

David Browne

Show quote Hide quote

"David Dong" <dongxiao***@hotmail.com> wrote in message
news:%23jvhNXWSGHA.4168@tk2msftngp13.phx.gbl...
> Hi All,
>
> The question is:
> Why do Ado.net don't use execution plan that Query Analyzer generate?
>
> I would be grateful if you can give me some directions.
>
> Best Regards,
> David
>
> "David Dong" <dongxiao***@hotmail.com> wrote in message
> news:O27lpRWSGHA.736@TK2MSFTNGP12.phx.gbl...
>>
>>
>> Hi All,
>>
>> I would be grateful if you can give me some directions.
>>

A difference in the SET options or a difference in the login account can
both cause a different plan to be used.

And, of course, if the query is not parameterized the same, it's not the
same query and won't get the same plan.

Daivd

18 Mar 2006 1:19 AM

David Dong

Hi David,

Thank you very much for your response.
I notice the 'arithabort' option is difference.and also i notice in
syscacheobjects table that includes a colume for the set bitmap.

I have also noticed a link that can help sb to troubleshoot these problem.

http://www.sqldev.net/misc/fn_setopts.htm

Best Regards,
David

Show quoteHide quote

"David Browne" <davidbaxterbrowne no potted m***@hotmail.com> wrote in
message news:%23%231T3FYSGHA.5156@TK2MSFTNGP10.phx.gbl...
>
> "David Dong" <dongxiao***@hotmail.com> wrote in message
> news:%23jvhNXWSGHA.4168@tk2msftngp13.phx.gbl...
>> Hi All,
>>
>> The question is:
>> Why do Ado.net don't use execution plan that Query Analyzer generate?
>>
>> I would be grateful if you can give me some directions.
>>
>> Best Regards,
>> David
>>
>> "David Dong" <dongxiao***@hotmail.com> wrote in message
>> news:O27lpRWSGHA.736@TK2MSFTNGP12.phx.gbl...
>>>
>>>
>>> Hi All,
>>>
>>> I would be grateful if you can give me some directions.
>>>
>
>
> A difference in the SET options or a difference in the login account can
> both cause a different plan to be used.
>
> And, of course, if the query is not parameterized the same, it's not the
> same query and won't get the same plan.
>
> Daivd
>