项目中一条SQL语句有严重的性能问题: SELECT role_goods.id,role_goods.number,roleId,role.`name` ,goods.`name` as '物品名称' from role_goods LEFT JOIN role on role.id =role_goods.roleId LEFT JOIN goods on good...(more)
一、抓取批量耗时最久的SQL:2、执行次数最多的TOP10SQL"db2 "select substr(stmt_text,1,500) as stmt_text,NUM_EXECUTIONS,TOTAL_USR_CPU_TIME,TOTAL_EXEC_TIME,SORT_OVERFLOWS from sysibmadm.snapdyn_sql order by NUM_EXECUTIONS desc fetch first 10 rows only"|gre...(more)