Hi all expert,
I am facing a problem .
I am having a query on PROD , which used to execute within 2-4 minutes till some days back.
Now its taking more than an hour, really dont know what is happening . Nothing has happen over a period of time.
We Checked the execution plan and found that it is using index seek.
Can't think what can be the cause. Has anyone faced the similar suituation . Any advice is highly appreciated .