How to add optimizer hint /*+ RULE */ for Toad when specific queries hang. (4286771)

How to add optimizer hints /*+ RULE */ when specific queries hang in Toad. Here's an example of when this option would help you.

Example:
Clicking the "Locks" tab in the Session Browser generates an automated query in the background by Toad. Sometimes the query can lock your Toad session. Setting the optimizer hints can resolve this issue.

You can add different hints to specific DLL queries or overall queries (recommended). To add the /*+ RULE */ optimizer hint:

1) Select View | Options | Oracle | Optimizer hints.
2) On the right, locate the "All other" drop down box. Select the appropriate hint /*+ RULE */ from the list.

3) Select "Apply" and "OK" to accept the changes.

4) Close Toad and restart the application for the changes to take affect.