I am new to DPA and need assistance on tuning high wait time quiries from tool

Question

I see the top query for a day ran for 10.4 hours(accross all execution) as below and but this query is not not active but the execution time is increasing.

sureshrs22 · Answer

Thanks! I will try to create functional index for where clause column in this query and check.

spaceman · Answer

I think that screenshot is from the query Analysis screen, if so and you scroll down there will be more information on average waits per execution and execution counts. I'd guess you're having a lot executions for that query with very short duration - so you do not see it as an active session under the current activity tab.