The Explain Window fails to launch (via F5) from the SQL Window when the SQL window contains a CTAS statement with subquery_factoring_clause. For example:
create table
as
with as
(
select ...
from ...
group by .... grouping sets (.....)
)
select ...
from
group by ..... ;
I have to manually copy and paste the statement form the SQL Window to a new Explain Window. There is nothing syntactically wrong with the CTAS. Once pasted in the Explain Window, it successfully returns an execution plan.
create table
with as
(
select ...
from ...
group by .... grouping sets (.....)
)
select ...
from
group by ..... ;
I have to manually copy and paste the statement form the SQL Window to a new Explain Window. There is nothing syntactically wrong with the CTAS. Once pasted in the Explain Window, it successfully returns an execution plan.
