Initialization Parameters, 157 of 222

PARTITION_VIEW_ENABLED

Parameter type	Boolean
Default value	`false`
Parameter class	Dynamic: `ALTER SESSION`
Range of values	`true \| false`

Note:

Oracle Corporation recommends that you use partitioned tables (available starting with Oracle8) rather than partition views. Partition views are supported for backward compatibility only.

PARTITION_VIEW_ENABLED specifies whether the optimizer uses partition views. If you set this parameter to true, the optimizer prunes (or skips) unnecessary table accesses in a partition view and alters the way it computes statistics on a partition view from statistics on underlying tables.

See Also:

Oracle9i Database Concepts for information on the advantages of partitioned tables and how to convert partition views to partitioned tables