#db2 “SELECT
row_read/(num_executions+ 1) as avg_rows_read,
orws_written/(num_executions + 1) as avg_rows_written,
stmt_sorts/(num_exections+ 1) as avg_sorts,
total_exec_time/(num_exectuions+ 1) as avg_exec_time,
substr(stmt_text,1,1000)as sql_stmt
FROMSYSIBMADM.SANPDYN_SQL
ORDERBY avg_exec_time DESC
FETCHFIRST 20 ROWS ONLY”
收起