Poor performing query – Microsoft Dynamics CRM Forum Community Forum

Forum Post: Change the Filter On option on Opportunity Associated View for Account form

We have a Dynamics CRM 365 onpremise with some webservices to fetch data for out other applications.

One of the webservices times out and when we trace in SQL what is happening we see that there is one SQL SELECT which reads miliions of rows and takes 88000 milliseconds.

Now, when we take that SQL query and run it separately in SqlServer Management Studio => same query takes 2000 milliseconds !

What can be behind this – it looks like when run from Dynamics CRM it will not use index – how can it work differently ?

Source link

Leave a reply

Please enter your comment!
Please enter your name here