I'm running Oracle SQL Developer Version 21.2.1.204, Build 204.1703. When I click on a table to open it - either double-click, or single-click and then click on the Data tab - a ‘Select *’ automatically executes. How can I prevent that from happening? For larger tables it takes upwards of 30 seconds.
I already have Tools→Database→Object Viewer→Open Object on Single Click UNchecked, and Tools→Database→Advanced→Sql Array Fetch Size set to the max 50.
Any other advice? I want this to be a global setting rather than one per table, or something I need to run every time I access a table. I'm hoping there's a global ‘Don’t do select * when accessing the Data tab' setting :)
Thanks!