Skip to main content
  • Log in

Menu principal

  • Quienes somos
  • Contact
  • Herramientas
  • twitter
  • linkedin
  • facebook
Home
  • TOP Software
    • Database
    • Data integration
    • Business intelligence
    • Data Science and AI
    • ERP
    • CRM
    • eMarketing
    • Business management
  • Blogs
  • News and resources

Main tematic navigation

  • Databases
  • Business Intelligence
  • Data Science

Breadcrumb

  1. Home
  2. Trucos

DB2 Top 10 SQL for number of executions

By Oscar_paredes on Sun, 09/29/2019 - 10:24
  • Read more about DB2 Top 10 SQL for number of executions
  • Log in to post comments

SQL sentence to obtain the SQL TOP TEN with more executions of my BD2 database:

db2 "SELECT NUM_EXECUTIONS as EXECUTIONS, 
     AVERAGE_EXECUTION_TIME_S as TIME_SECONDS, 
     STMT_TEXT as TEXT   
     FROM SYSIBMADM.TOP_DYNAMIC_SQL   
     WHERE upper(STMT_TEXT) like 'SELECT%' 
     ORDER BY NUM_EXECUTIONS DESC 
     FETCH FIRST 10 ROWS ONLY"
Subscribe to Trucos

Featured software

Semrush

SemrushSemrush is a web tool for SEO and SEM analysis, focused on the search for keywords (Keyword Research) and competitive analysis.
This web tool, pay per use, provides a user-friendly analysis using data giving access to organic positioning and pay per click for the top 20 positioned keywords in the search…

Promoted Resources

Today's Top Picks for Our Readers:

Recommended by Recommended by NetLine

Suscríbete a nuestro boletín

  • twitter
  • linkedin
  • facebook

Dataprix TOP Technology blogs

Creative Commons License  This work is licensed under a Creative Commons Attribution-Share Alike 4.0 License.

Clear keys input element