Develop the graphical query plan

Details

Description

  • 텍스트 및 트리 방식 질의 계획이 많은 정보를 한 번에 출력하여 복잡함
  • 단순하면서 필요한 정보만 제대로 전달하는 도구가 필요
  • text及tree方式的query计划，一次显示了所有信息，有些混乱
  • 需要的是准确显示出简单及必要信息的工具

Issue Links

relates to

Bug - A problem which impairs or prevents the functions of the product. TOOLS-2729 After run a sql in query editor first time.Modify 'Where rownum between ... and...', the card not changed in Query Explain.

  • Minor - Minor loss of function, or other problem where easy workaround is present.
  • Closed - The issue is considered finished, the resolution is correct. Issues which are closed can be reopened.

Bug - A problem which impairs or prevents the functions of the product. TOOLS-2730 When where has datatime compare,query explain has error.

  • Minor - Minor loss of function, or other problem where easy workaround is present.
  • Closed - The issue is considered finished, the resolution is correct. Issues which are closed can be reopened.

Bug - A problem which impairs or prevents the functions of the product. TOOLS-2731 Query plan can't recongnize join when sql has 'WHERE'

  • Minor - Minor loss of function, or other problem where easy workaround is present.
  • Closed - The issue is considered finished, the resolution is correct. Issues which are closed can be reopened.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Isaiah Choe added a comment - - edited

각 query plan node 사이의 관계를 쉽게 알 수 있도록 그래프로 개선하였고, 각 node는 적절한 메타포의 아이콘으로 출력하여 가독성을 높였습니다.
已对query plan node 之间的关系用graph进行了改善，并将各个node以适当的mataphor 图标显示提高了可读性。

Show
Isaiah Choe added a comment - - edited 각 query plan node 사이의 관계를 쉽게 알 수 있도록 그래프로 개선하였고, 각 node는 적절한 메타포의 아이콘으로 출력하여 가독성을 높였습니다. 已对query plan node 之间的关系用graph进行了改善，并将各个node以适当的mataphor 图标显示提高了可读性。
Hide
Permalink
董志玲(Ella) added a comment - - edited

1. In the Second display mode. Table shows twice.
2. Cost in history is not correct.
see queryExplain1.png

Show
董志玲(Ella) added a comment - - edited 1. In the Second display mode. Table shows twice. 2. Cost in history is not correct. see queryExplain1.png
Hide
Permalink
Isaiah Choe added a comment -

1.
Duplicated table name is not a bug from a raw query plan.
If the query which is executed by the user, has a table name with an alias, it will be displayed with a table name and an alias on there.
But, I understand your viewpoint, I'd like to fix this issue for users.

2.
I will fix this bug.
For reference, before cubrid 9.0, it was shown as "fixed cpu, variable cpu, fixed io, variable io".
It will be shown only total cost for easy to read after this release.

Show
Isaiah Choe added a comment - 1. Duplicated table name is not a bug from a raw query plan. If the query which is executed by the user, has a table name with an alias, it will be displayed with a table name and an alias on there. But, I understand your viewpoint, I'd like to fix this issue for users. 2. I will fix this bug. For reference, before cubrid 9.0, it was shown as "fixed cpu, variable cpu, fixed io, variable io". It will be shown only total cost for easy to read after this release.
Hide
Permalink
Isaiah Choe added a comment -

Fixed to display with wrong costs in the query plan history pane.

Show
Isaiah Choe added a comment - Fixed to display with wrong costs in the query plan history pane.
Hide
Permalink
董志玲(Ella) added a comment -

Close in build 9.1.0.0018.
comment bug:
1,not a bug.
2,fixed

Show
董志玲(Ella) added a comment - Close in build 9.1.0.0018. comment bug: 1,not a bug. 2,fixed

People

  • Assignee:
    Isaiah Choe
    Reporter:
    Isaiah Choe
Vote (0)
Watch (2)

Dates

  • Created:
    Updated:
    Resolved: