DB2 Top 10 SQL for execution time
- Read more about DB2 Top 10 SQL for execution time
- Log in to post comments
SQL Command to obtain the Top Ten of SELECT SQL sentences with more execution time in your DB2 database:
db2 "SELECT AVERAGE_EXECUTION_TIME_S as TIME_SECONDS, NUM_EXECUTIONS as EXECUTIONS, STMT_TEXT as TEXT FROM SYSIBMADM.TOP_DYNAMIC_SQL WHERE upper(STMT_TEXT) like 'SELECT%' ORDER BY AVERAGE_EXECUTION_TIME_S DESC FETCH FIRST 10 ROWS ONLY"