Hi Amit,
You are doing a nested loop full index scan. Either get it to do that as a
hash join or find it a better index which can be accessed with the join
predicates.
Thanks,
Andy
On Mon, 25 Oct 2021 at 18:15, Amit Saroha <eramitsaroha@xxxxxxxxx> wrote:
Hi Listers,
Database version - 12.0.1
I have a query that is running from long but couldn't understand the
reason for the long run. I have enclosed the SQL monitoring and SQL plan
for reference.
In LongOps it shows its reading blocks but doesn't know why reading is so
slow. Could you please suggest what could cause such an issue?
Best Regards,
AMIT