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