达梦数据库查看执行计划

两种格式，一个是explain ，一个是explain for (更详细的计划）

构造环境

create table t1 as select rownum as id ,rownum+1 as id2,rpad(’’,1000,’’) as contents from dual connect by level<=1;

操作已执行

2 create index idx_id_t1 on t1(id);

操作已执行

已用时间: 219.620(毫秒). 执行号:16.

SQL> explain select * from t1 where id=1;

1 #NSET2: [0, 1, 72]

2 #PRJT2: [0, 1, 72]; exp_num(4), is_atom(FALSE)

3 #BLKUP2: [0, 1, 72]; IDX_ID_T1(T1)

4 #SSEK2: [0, 1, 72]; scan_type(ASC), IDX_ID_T1(T1), scan_range[exp_cast(1),exp_cast(1)]

已用时间: 0.504(毫秒). 执行号:0.

explain for 可以看到更详细的方式，只是目前格式化程度并不好，有些看不清楚

SQL> explain for select * from t1 where id=1;

行号 PLAN_ID PLAN_NAME CREATE_TIME LEVEL_ID OPERATION TAB_NAME IDX_NAME SCAN_TYPE SCAN_RANGE ROW_NUMS BYTES COST CPU_COST IO_COST

---

       FILTER JOIN_COND ADVICE_INFO PSTART      PSTOP