December 2002
Intermediate to advanced
928 pages
85h 29m
English
PARTITION_VIEW_ENABLED
Value: TRUE | FALSE
Default: FALSE
Specifies optimizer behavior for partitioned views. If TRUE, the optimizer prunes or skips unnecessary table accesses in a partition view. Also changes the way the cost-based optimizer computes statistics on a partition view from statistics on underlying tables.