Very annoying delay when invoking code completion

[developeris]

Do a simple query
select o.* from all_objects o;

Then position cursor to o.*, delete the * and invoke code completion, i.e. on screen it looks like

select o. from all_objects o;

The list with the columns comes up, I select the first value (All) and press enter and then I have to wait for at least 15 seconds until I get the result like

select WNER,
BJECT_NAME,
o.SUBOBJECT_NAME,
BJECT_ID,
o.DATA_OBJECT_ID,
BJECT_TYPE,
o.CREATED,
o.LAST_DDL_TIME,
o.TIMESTAMP,
o.status,
o.TEMPORARY,
o.GENERATED,
o.SECONDARY,
o.namespace,
o.EDITION_NAME,
o.SHARING,
o.EDITIONABLE,
RACLE_MAINTAINED from all_objects o;

Very, very annoying. I think it's related tohttps://forums.allroundautomations.com/ubb/ubbthreads.php?ubb=showflat&Number=57231#Post57231, as it's again retrieving comments and what not in the background.

Developer version 12.0.6.

 

[Marco Kalter]

To prevent this you can go to Preferences > User Interface / Code Assistant and disable the "Use original case if possible" option. This way the Code Assistant does not need to fetch the view definition to determine the case of the columns in the source.

 

[developeris]

Thank you, so much better now.