Teradata Delete Sessions going into responding state
I have faced a scenario recently where the DELETE statements are going into RESPONDING state. I am aware that the sessions which run SELECT will be going into the RESPONDING state if the result is being written into a file.
I have tried to find the root cause. But couldnt find. Please help me out with this.