I have 2 enviroments.In one enviroment query runs within 7 seconds ,in another enviroment it takes 4 hours. Both have same memory,cpu core,same partitions.
There is no blockings as well.
memory ultization is 50% and cpu utilization is 60%. What will be a issue?It's nightmare ...
I have rebuilded thee index and updated the stats but no luck.