Oracle9i Database Reference Release 1 (9.0.1) Part Number A90190-02 |
|
Initialization Parameters, 155 of 220
Parameter type |
Boolean |
Default value |
|
Parameter class |
Dynamic: |
Range of values |
|
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 |
|
![]() Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|