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,