OPTIMIZER_MODE：OPTIMIZER_MODE establishes the default behavior for choosing an optimization approach for the instance. Values: first_rows_n - The optimizer uses a cost-based approach and optimizes with a goal of best response time to return the first n rows (where n = 1, 10, 100, 1000). first_rows - The optimizer uses a mix of costs and heuristics to find a best plan for fast delivery of the first few rows. all_rows - The optimizer uses a cost-based approach for all SQL statements in the session and optimizes with a goal of best throughput (minimum resource use to complete the entire statement). Parameter Type: String Syntax: OPTIMIZER_MODE = { first_rows_[1 | 10 | 100 | 1000] | first_rows | all_rows } Default Value: all_rows Modifiable: ALTER SESSION, ALTER SYSTEM
错误码
错误描述：OPTIMIZER_MODE establishes the default behavior for choosing an optimization approach for the instance.
Values:
first_rows_n - The optimizer uses a cost-based approach and optimizes with a goal of best response time to return the first n rows (where n = 1, 10, 100, 1000).
first_rows - The optimizer uses a mix of costs and heuristics to find a best plan for fast delivery of the first few rows.
all_rows - The optimizer uses a cost-based approach for all SQL statements in the session and optimizes with a goal of best throughput (minimum resource use to complete the entire statement).
Parameter Type: String
Syntax:
OPTIMIZER_MODE =
{ first_rows_[1 | 10 | 100 | 1000] | first_rows | all_rows }
Default Value:
all_rows
Modifiable: ALTER SESSION, ALTER SYSTEM
向认证技术专家提问
向技术专家提问
