I often run ad-hoc sql queries, and rely heavily on the code assistant (cool feature by the way) to retrieve the column names for the table. However, when I reference several tables, the code assistant goes out and re-retrieves the same column names again.
e.g. in the following query:
select * from customer ct, company cp
where ct.company_name = cp.company_name
and ct.title = 'Manager'
when typing out the where clause, the code assistant will retrieve first the columns names for ct (3 seconds), then cp (3 seconds), then
ct again (3 seconds).
Would it not be possible to just cache the data dictionary info retreived so far (for the active session) - so that for the example above, the second retrieval for ct is instantaenous, since the information is already cached?
The database server is situated on another continent by the way, so it does take a few seconds before the code assistant is able to display the table columns
e.g. in the following query:
select * from customer ct, company cp
where ct.company_name = cp.company_name
and ct.title = 'Manager'
when typing out the where clause, the code assistant will retrieve first the columns names for ct (3 seconds), then cp (3 seconds), then
ct again (3 seconds).
Would it not be possible to just cache the data dictionary info retreived so far (for the active session) - so that for the example above, the second retrieval for ct is instantaenous, since the information is already cached?
The database server is situated on another continent by the way, so it does take a few seconds before the code assistant is able to display the table columns
