Hi All,
oracle 19c is our db version running in exadata machine.
We have a Select statement that is having 4K lines and was working fine and returning result in 2 minutes. Now we added few more lines in the column list ( sum(case( .. )) - now the 7K lines in the SELECT.
After this the Explain plan statement on this SQL itself is not returning results. Sometimes teh explain plan will return result after 20 minutes.
When the new lines are removed from select list ( without any other changes ) its running without issues.
Any thoughts ?
If there is any documents on SQL length impacting plan generation please share.
Any suggestions are highly appreciated.
Thanks