Initialization Parameters, 145 of 188

PARTITION_VIEW_ENABLED

Parameter type:	Boolean
Parameter class:	Dynamic. Scope = `ALTER` `SESSION.`
Default value:	`FALSE`
Range of values:	`TRUE` \| `FALSE`
Note: Oracle Corporation recommends that you use partitioned tables (available beginning 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 it 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: Oracle8i Concepts for information on the advantages of partitioned tables, and how to convert partition views to partitioned tables.