Hi Expert - I have been asked in a recent interview regarding the identification of bottleneck for a long running SQL query.
In detail, till yesterday it was running nicely but today we are getting issue and running for long time which means it was good in all perceptions - CPU, memory,partition,index,joins etc...
Can you suggest me what would be the root cause for this issue apart from the issues mentioned above?
Thanks
Sen