Issue: Execution Plan Generation - Complex Statements
Posted: Wed 11 Jul 2012 19:43
Issue:
dbForge Studio for Oracle (v3.1.206) fails to generate execution plans for complex statements.
Steps to Reproduce:
1 - Connect to database
2 - Open new SQL tab/document (CTRL-N)
3 - Enter a complex statement, for example:
4 - Generate Execution Plan using the toolbar icon or by the menu barl (SQL/Generate Execution Plan)
Expected Result:
Execution plan is generated for evaluation, for example:
Actual Result:
Error: This statement cannot be profiled.
dbForge Studio for Oracle (v3.1.206) fails to generate execution plans for complex statements.
Steps to Reproduce:
1 - Connect to database
2 - Open new SQL tab/document (CTRL-N)
3 - Enter a complex statement, for example:
Code: Select all
WITH
MYTABLE AS (
SELECT 1 COL_A FROM DUAL
),
MYTABLE2 AS (
SELECT 2 COL_A FROM DUAL
),
MYTABLEUNION AS (
SELECT * FROM MYTABLE
UNION
SELECT * FROM MYTABLE2
)
SELECT * FROM MYTABLEUNION;
Expected Result:
Execution plan is generated for evaluation, for example:
Code: Select all
SELECT STATEMENT COST=6
VIEW COST=6
SORT (UNIQUE) COST=6
UNION-ALL
FAST_DUAL COST=2
FAST_DUAL COST=2
Actual Result:
Error: This statement cannot be profiled.