OBIEE - Hint

> Reporting and Data Access Tools > Oracle Business Intelligence (OBIEE/Siebel Analytics) > OBIEE - BI Server (OBIS|nqsserver|nqs)

1 - 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.

3 - 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
Advertising

4 - Documentation / Reference