Claus Pedersen
Member³
I am defining a foreign key using the table editor. When I type the first letter of a table name in the column "Referencing Table" PLD hangs for about 2 minutes before it comes up with a list of tables beginning with the letter I typed. In that period, I can not use PLD for anything else.
I can see that it is the query
that takes up the time. The above select gives 822 tables on my current database user (all tables owned by the current user).
I would request
1) that this querying for table names begins only after a short delay with no typing activity, like code completion (
I can see that it is the query
SQL:
select owner, object_name
from sys.all_objects
where object_type = 'TABLE'
and object_name not like 'BIN$%'
order by decode(owner, user, 0, 1), owner, object_nameI would request
1) that this querying for table names begins only after a short delay with no typing activity, like code completion (
