Oracle9i Database Reference Release 2 (9.2) Part Number A96536-02 |
|
|
View PDF |
Parameter type |
Boolean |
Default value |
|
Parameter class |
Dynamic: |
Range of values |
|
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 |