Clear query result before running new query
已回答
I switched from SQL Workbench/J to DataGrip and so far so good. There are, however, few little things that I miss or hopefully can't just find in settings.
The main one is so that the console query results are cleared when I resubmit the query. Sometimes I don't know if the query ran or not because there isn't a lot of indication that the query has run. Is it possible?
请先登录再写评论。
@Dawid Nawrot,
You can check execution time in SQL Log which is in Output:
Also, if you need to pin results and execute another one - use Pin Tab
And result set comparison tool
It's not really what I'm after. While having query Result 1 in the view, when I change the query and execute it again I would like it to be cleared before the new query runs. It's still the same query but perhaps with more refined filters and sometimes, if query takes a long time I won't know if it executed unless I do all these extra steps of checking the log.
If I press Execute and see that previous results are cleared then I already know that what I'll see once it's completed are the new results.
@Dawid Nawrot,
> if query takes a long time I won't know if it executed unless I do all these extra steps of checking the log.
There is a notification for long running queries in Event Log.
But the best way to track Output to ensure what was executed or not.
It also requires witching windows, unnecessary extra step. When I press CTRL+E and keep changing the query that log becomes less useful by the minute as you have to keep looking at the time, not to mention I am able to change query few times within one minute.
At the moment the only indication of running new query is this:
Also not very prominent, is it?