#StackBounty: #sqldeveloper Improve SQL developer performance at query builder

Bounty: 200

I use Oracle SQL Developer (version 17.3.1.279) in Windows 10 64 bit.
It’s connected to an Oracle database in the network through TNS.

Whenever I open “query builder” first time for a query, or after some changes in the SQL code it takes a lot of time (30-60 s) to load.

Also “completion insights” appear very slow (3-4 s), so I generally just finish typing table and column names before they appear (setting is 0.6 s for them to appear).

Based on above issues, I suspect SQL developer each time reads information from the database. Is there a way to make it store information locally instead? (structure of the database is quite permanent, it changes less then once a year)


Get this bounty!!!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.