Finding expensive database queries

Your database is under a lot of pressure to perform. So are you. Add a little rest and relaxation to your routine when you optimize queries. Clarity can show you the databases most in need of tuning.

To find the most expensive queries:

  • Go to Database Management in the left sidebar.
  • Scroll down to the Analysis section to find the Most Expensive Queries table.
  • Hover over the ellipsis in the SQL column or click to view the full query.
  • These may provide opportunities for tuning.
    Most expensive queries