I'm really stuck on this. I have a SQL that when I execute an Explain on it, it shows a very fast execution.
When the application runs the SQL, it takes another Explain plan and very expensive set of Cartesian Products
This is an Oracle 12C database.
Any ideas would be greatly appreciated.