This content has been marked as final. Show 2 replies
I ran a query in Oracle SQL Developer reading exadata database.
I am running a query which is taking 2 hours to run.
The query is as follows:
The plan for the query and the predicate information are also attached.
The problem: optimizer is identifying a join to be merge join cartesian. (operation 12)
But if we remove the filter conditions (mark lewis and account filter from the where clause), the query completes in 2 mins (and with cartesian join).
If i use inline query it does not throw any issues and runs swiftly.
Any ideas on why this is happening will be appreciated.