PT : Hints Covered in the Lecture

Optimizer goal

• All_rows
• First_rows(n)

Table and Index Access Paths

• Full
• Index
• Index_FFS
• Index_SS
• No_INDEX

Join Order

• Ordered
• Leading

Joins

• USE_NL
• USE_HASH
• USE_MERGE

SQL Block Name

• QB_NAME