Mostly I love Toad Insight and have it turned on with all options and the pop-up delay set to the lowest allowed. There are a couple of issues though that make it get in the way sometimes.
1 - The order of the suggestions causes it to pick the wrong option when I just try to type.
For example, If I type “select * from table where col1 in (select …);” then when I start typing “in” the list pops up, but it automatically puts the suggestion of INTERSECT above IN so that if I type “in” and hit the space bar, it inserts the word INTERSECT.
likewise, typing “select” will tend to make it auto-select a table we have called selection_types.
This could be easily fixed by changing the order of the suggestions so that it is alphabetical order, or in length order - or just if what we have typed so far is a valid suggestion, automatically go with that.
2 - If the list is slow to pop up (presumably because it is querying the database) then TOAD freezes and by the time it appears it will often leave out a lot of what I have typed - or automatically made incorrect selections from the list.