RE: sql explain for formart detail

["Liu, Yuan (Yuan)" <yu...@esgyn.cn>]

Does "get statistics" meet your requirement?

Get statistics for qid <qid> default;
Get statistics for qid <qid> progress;
Get statistics for qid <qid> accumulated.



-----Original Message-----
From: liyun <yu...@esgyn.cn> 
Sent: Wednesday, August 22, 2018 10:24 PM
To: user@trafodion.apache.org; dev@trafodion.apache.org
Subject: sql explain for formart detail

Hi expert,

I recently encountered SQL performance issues in my project. In Esgyndb, you can simply output the execution plan

access , but this info doesn't help me see SQL performance issues. So please ask if you can provide some 

tools to format explain. 

ex: db2 database provide to use db2exfmt tool from package cache

I would like to know some performance metrics, such as parsing time, physical reads, logical reads, sort overflows, and 

the cost of executing the plan selection path.


Thanks

pual