When using the built in SQL / Auto Optimizer in v12.1, it hangs Toad when it optimizes a statement. The same statement works fine in 12.0. It always hangs at the same point and you have to stop the Toad process in order to proceed.
This can be replicated in the SCOTT schema, using the following statement:
SELECT DNAME,
LOC,
MGR,
EMP.JOB,
HIREDATE,
EMP.COMM,
EMP.DEPTNO,
EMP.ENAME,
BONUS.JOB,
BONUS.SAL,
BONUS.ENAME,
LOSAL,
HISAL
FROM DEPT
INNER JOIN EMP ON (DEPT.DEPTNO = EMP.DEPTNO)
CROSS JOIN BONUS CROSS JOIN SALGRADE
If you choose to optimize using the default settings, it crashes after testing the 31st alternative.
WORKAROUND:
Please run the Auto-Optimizer using Toad for Oracle v12.0.
STATUS:
Waiting for fix in a future release of Toad for Oracle
