Hi All
There is a big view which we use for fill a temp Table.
There is a job which run every minute and generally it takes 30s.
One week ago, something happens and the running time grown up 5m.
I tried to figure out why, but I have no idea.
If I select all the data from the view It takes 20s and the insert part takes more than 4m
Thank you for any ideas