HI everybody,
I just killed the session which was executing the delete operation and then retried. Guess what? The same operation took less than 2 seconds, beats me what was wrong earlier, though.
Can someone help in knowing what might have been wrong? Like I said earlier, only one session was going on when the problem occured.
Thanks
manjunath