通过 sysmaster:syssqexplain 优化SQL

select

first 25 sqx_estcost,sqx_estrows,sqx_sqlstatement

from sysmaster:syssqexplain

order by sqx_estcost desc;

更多的属性,如通过sqx_seqscan找出顺序扫描的SQL，通过sqx_dsksorts找到有磁盘排序的SQL。

其他的属性如下：

sqx_bufreads,sqx_pagereads,sqx_bufwrites,

sqx_pagewrites,sqx_totsorts,sqx_dsksorts,

sqx_sortspmax,sqx_conbno,sqx_ismain,sqx_selflag,

sqx_estcost,sqx_estrows,sqx_seqscan,sqx_srtscan,

sqx_autoindex,sqx_index,sqx_remsql,sqx_mrgjoin,

sqx_dynhashjoin,sqx_keyonly,sqx_tempfile,