We’ve recently upgraded our TOAD from 5.3 to 6.1.
Everything seems fine except the auto completion performance while writing a join statement.
Code completion for selects from a single table is lightning fast, until a second table comes into picture with a join statement.
As far as I can see, TOAD is trying to get the links of the the tables in the shema based on their FKs and list them at top of the auto complete list.
As the shema gets bigger, the poorer the perfomance gets. Version 5.3 was performing better than 6.1 and writing queries without the help of auto complete costs us a lot of time.
Can anybody suggest a way to improve the perfomance or is there a way to prevent code completion from reading the table relations?