Oracle8i Reference
Release 2 (8.1.6)

A76961-01

Library

Product

Contents

Index

Prev Up Next

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. 


Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index