Issue: Execution Plan Generation - Complex Statements

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
wi937c-amr
Posts: 16
Joined: Fri 29 Jun 2012 19:49

Issue: Execution Plan Generation - Complex Statements

Post by wi937c-amr » 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:

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;
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:

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.

alexa
Devart Team
Posts: 2424
Joined: Fri 24 Jun 2011 14:17

Re: Issue: Execution Plan Generation - Complex Statements

Post by alexa » Thu 12 Jul 2012 15:56

This issue will be fixed in the next build of the product.

wi937c-amr
Posts: 16
Joined: Fri 29 Jun 2012 19:49

Re: Issue: Execution Plan Generation - Complex Statements

Post by wi937c-amr » Thu 12 Jul 2012 17:41

Thank you for the update.

Post Reply