I am on Toad 15.1 (Latest version) and code assists does not work pretty well. If I select Join Suggestion, it takes forever saying "Loading constrains..." But nothing happen. If I uncheck this option, only tables, views and users are recover, but missing all objects such as procedures or functions.
I understand that it's taking a long time, but how long did you wait?
It should only have to load constraints one time, so if you let it finish, then the next time the code asssist window appears, it won't run any queries at all and will be very fast.
Procedures, packages, etc, are not controlled by the "Join Suggestions" option. They have their own checkboxes in the same place in options. Please double-check that.
Exactly, procedures and functions were unchecked. After Check, problem was solved. And know (after loading Constrains for 3 minutes), it is much faster,