About
Database hints are instructions placed within a SQL statement that tell the database query optimizer the most efficient way to execute the statement.
Hints override the optimizer’s execution plan, so you can use hints to improve performance by forcing the optimizer to use a more efficient plan (way to execute the query).
Hints are database specific. The Oracle BI Server supports hints only for Oracle 8i, 9i, and 10g and 11g servers.
Articles Related
Database Objects That Accept Hints
| Database Object | Dialog Box |
|---|---|
| Physical complex join | Physical Join - Complex Join |
| Physical foreign key | Physical Foreign Key |
| Physical table - object type of Alias | Physical Table - General tab |
| Physical table - object type of None | Physical Table - General tab |