The Set Designer Statement Hint dialog box enables an Oracle SQL hint to be placed on a rule. Hints are quite technical and should not be applied to rules randomly. Usually the only reason to apply a hint is to improve performance. Any valid Oracle hint can be applied to a DataBee rule - simply type it into the field on the Statement Hint Dialog box. Do not enter the /*+ and */ markers for the hint - DataBee will add these when it constructs the SQL statement.
If you wish to apply a hint to all rules there is no need to edit each rule individually. To make a hint apply globally set the option on the Set Designer Misc. Setup tab. Hints applied to individual statements will always override the global SQL Hint.
Note: If the cost based optimizer is being used, the best performance can be almost always be obtained by making sure all tables in the source schema are analyzed. If the statistics on the tables are good it is rarely necessary to apply individual hints to statements.
Also Note: Any hints entered from within the Set Extractor application are temporary. They will not be saved after the application shuts down or an Extraction Set is loaded or re-loaded. In order to permanently apply a hint to a rule use the Set Hint button on the Set Designer Set Rules tab.