OPTIMIZER_USE_PENDING_STATISTICS


Property Description

Parameter type

Boolean

Default value

true

Modifiable

ALTER SESSION, ALTER SYSTEM

Range of values

true | false

Basic

No


OPTIMIZER_USE_PENDING_STATISTICS specifies whether the optimizer uses pending statistics when compiling SQL statements.

See Also:

Oracle Database SQL Tuning Guide for more information on setting this parameter