Hi All,
SQL Developer version: 4.0.0.13 (Windows)
Upon submitting a simple SELECT * FROM <any_app_related_table> query in a worksheet the response time to return results have been awful - this is especially apparent when running the query upon opening the worksheet as a new connection.
I decided to track the activity of my session and found that upon submitting the query the following SQL was executed BEFORE the actual query I wanted is run:
/*+ NO_SQL_TRANSLATION */
select table_owner, table_name from all_synonyms where owner in (user,'PUBLIC') and synonym_name=:1
and not exists (select user, object_name from user_objects where object_name=:2 and object_type in ('TABLE','VIEW'))
Because a couple of our DB's have massive data dictionarys, the above SQL is taking it's time in executing. We have gathered stats on the DD before but this does not make any difference.
Is there any way this kind of "pre-query" behaviour can be switched off within SQL Developer? My colleagues using tools such as TOAD laugh in my face as their queries execute instaneously. I have tried searching for this behaviour on the web but could not find anything.....
PS - I seem to think I've asked this question before as I've seen this behaviour on previous versions also but I think the answer was simply words to the effect of "that's the way SQL Developer operates I'm afraid".
Thanks in advance