PT - Optimizer using SQL hints

Hints  /* +  */

Types of Hints we can use while executing queries below, We will discuss with examples on upcoming days with URL  location:

• Optimizer Goal

1. All_Rows
2. First_Rows(n)

ALTER [SYSTEM|SESSION] SET OPTIMIZER_MODE='ALL_ROWS'

ALTER [SYSTEM|SESSION] SET OPTIMIZER_MODE='FIRST_ROWS_n'

• Table and Index Access Path

1. Full
2. Index
3. Index_FFS
4. Index_SS
5. No_Index

• Join Order

1. Ordered
2. Leading

• Joins Methods

1. USE_NL
2. USE_HASH
3. USE_MERGE

• SQL BLOCK NAME

1. QB_NAME