Queries Max Exec Time
- Graph in the left bottom section, shows the top 10 max time-consuming queries.
- If the time is too high, you may want to look at the query plan and improve them as needed.
- The most likely scenarios you may encounter are:
- Too many disk blocks being read. In such a case, you may want to consider partitioning the table.
- Query may not be using the keys and indexes efficiently. In such as case you may want to index the table on required columns, or include partition keys in the query.
