Improvement of the Query Plan

Details

Description

현재 Query plan의 데이터는 직접 XML로 저장해야만 한다. 그러나, 불편하다.
유저가 저장하지 않아도 저장으로 prefs 등에 저장될 수 있어야 한다.
저장은 한곳에 모든 query plan이 저장되는 것이 아니라 DB별로 query plan이 저장되면 될 것이다.

plan.PNG 참조

아래 빨간색 네모버튼 외의 모든 버튼 제거, 아래 빨간색 영역 불필요
(1)번 버튼에 의해 TEXT, 테이블형 출력 모드를 변경할 수 있으므로 아래 TEXT형 plan을 테이블형 모드에 함께 출력할 필요는 없음.

–

目前Query plan的数据只能直接保存为XML。但是，很不方便。
就算用户不保存也应该可用prefs 等进行保存。
不将所有的query plan都保存在一个地方，而是按着各个DB来保存query plan即可。

请参考plan.PNG

删除除了红色方框内的所有按钮，下面的红色方框区域不需要。
由于用(1)号按钮就可改变TEXT, table型的模式所以不用将下面的TEXT型plan在table型模式上一起显示

  1. File
    TOOLS-921.creview
    19/Apr/12 5:01 AM
    70 kB
    付雷
  1. plan.PNG
    40 kB
    10/Apr/12 11:20 PM

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Li Ling added a comment -

Description:
目前Query plan的数据只能直接保存为XML。但是，很不方便。
就算用户不保存也应该可用prefs 等进行保存。
不将所有的query plan都保存在一个地方，而是按着各个DB来保存query plan即可。

请参考plan.PNG

删除除了红色方框内的所有按钮，下面的红色方框区域不需要。
由于用(1)号按钮就可改变TEXT, table型的模式所以不用将下面的TEXT型plan在table型模式上一起显示

Show
Li Ling added a comment - Description: 目前Query plan的数据只能直接保存为XML。但是，很不方便。 就算用户不保存也应该可用prefs 等进行保存。 不将所有的query plan都保存在一个地方，而是按着各个DB来保存query plan即可。 请参考plan.PNG 删除除了红色方框内的所有按钮，下面的红色方框区域不需要。 由于用(1)号按钮就可改变TEXT, table型的模式所以不用将下面的TEXT型plan在table型模式上一起显示
Hide
Permalink
付雷 (Inactive) added a comment -

Fixed

Show
付雷 (Inactive) added a comment - Fixed
Hide
Permalink
付雷 (Inactive) added a comment - - edited

test step
1.open query editor
2.input a select statement "SELECT * FROM agent;"
3.press "F6" or press "Display query plan" button
4.check the information displayed on "Query Explain" whether the 4 buttons of xml logic had been deleted
5.close the CM then open CM and a new query editor again .check the plan history list whether display the old plan
6.select some plan historues then click "delete" button .check whether the plan had been deleted
7.close the CM then open CM and a new query editor again, check whether the plan had been deletedeted

Show
付雷 (Inactive) added a comment - - edited test step 1.open query editor 2.input a select statement "SELECT * FROM agent;" 3.press "F6" or press "Display query plan" button 4.check the information displayed on "Query Explain" whether the 4 buttons of xml logic had been deleted 5.close the CM then open CM and a new query editor again .check the plan history list whether display the old plan 6.select some plan historues then click "delete" button .check whether the plan had been deleted 7.close the CM then open CM and a new query editor again, check whether the plan had been deletedeted
Hide
Permalink
高艳铭 added a comment -

Fixed in CM8.4.1.2100

Show
高艳铭 added a comment - Fixed in CM8.4.1.2100
Hide
Permalink
高艳铭 added a comment -

Fixed in CQB8.4.1.2109

Show
高艳铭 added a comment - Fixed in CQB8.4.1.2109

People

  • Assignee:
    高艳铭
    Reporter:
    Isaiah Choe
Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved: