With the extension "Oracle SQL Developer Extension for VSCode," the Intellisense and autocomplete features are very slow at proposing column names (it continually displays "Loading..." until the column name suggestions appear many seconds later).
With the previous extension, "Oracle Developer Tools for VSCode (SQL and PLSQL)," these features were extremely efficient, fast, and instantaneous when proposing column names. You could even see the details of a table's columns by hovering over them in the edited SQL statement.
I know that the previous extension cached the entire data dictionary of the database into memory.
We have fresh statistics on our data dictionary but we use big table with a lot of columns (50 o more) in our databases and now is very very slow to get columns information and autocomplete.
Please add the option to catch data dictionary using and especific configuration in extension's settings for example.
This is very useful to make a fast query on big tables like we could make with "Oracle Developer Tools for VSCode (SQL and PLSQL)"