Help with slow query
Hi,
I have a query that takes over 2min. Attached is the query with the plan report because it is too long to copy here.
I found the sql_id for this query as 4knpb2ccngc4z. Attached is the ASH report
Maybe an index is missing...
How can I start doing the analysis?
Thanks!