Can I abort the Count Rows operation in SQL Developer?

When I execute the query and right-click in the results pane, I get a popup menu with the following options:

  • Save grid as report ...
  • View a single recording ...
  • Read lines ...
  • Find / Select ...
  • Export...

If I select "Count Rows", is there a way to abort the operation if it starts too long?

+6
source share
2 answers

No, you do not seem to be able to.

When you select Count Rows from the context menu, it starts counting in the main user interface thread, hanging the entire user interface, possibly for minutes or hours.

It’s better not to use this function - just set select count (*) from ( < your query here>) , which it starts correctly in a separate thread, which can be undone.

+8
source

You can open a new sql developer instance and kill the row-counting session. I suggest using a select count(*) query, although in the long run this is less painful.

+3
source

Source: https://habr.com/ru/post/912954/


All Articles