14.2.1 Types of SQL hints

For information about using the Hints, see the Using Optimizer Hints section in the Oracle Database Performance Tuning Guide, 11g Release 2 (11.2).

Note:

• Hints must be defined by users; there are no default hints.
• There is currently no user interface for the definition of hints. Your DBA can assist you in defining, testing, and optimizing SQL Hints. SQL Hints must be manually inserted into the FSI_OPTIMIZATION_SETTINGS table.
• You may determine an allocation's SYS_ID_NUM by performing a mouse-over on the allocation rule's name in the Allocation Specification summary screen.
• Hints are limited to 250 characters for each SOURCE_HINT and TARGET_HINT.