Skip to Main Content
Oracle Data Warehouse Tuning for 10g
book

Oracle Data Warehouse Tuning for 10g

by Gavin JT Powell
April 2011
Intermediate to advanced content levelIntermediate to advanced
504 pages
16h 49m
English
Digital Press
Content preview from Oracle Data Warehouse Tuning for 10g
11.3
Affecting Query Rewrite Performance 331
Chapter 11
hash partitions [1]. Partition query rewrite is known as PCT
query rewrite. A materialized view can include a partition marker
as a replacement for a partition key. The partition marker allows
specific identification of specific partitions, allowing query rewrite
on those marked partitions as pruned partitions. A partition
marker can identify one or more individual partitions. Once
again, all rows in a marked partition must be accessed for parti-
tioned query rewrite to occur. Also, only wholly fresh partitions
can be used for query rewrite. Only fresh partitions have an avail-
able partition marker ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle 10g Data Warehousing

Oracle 10g Data Warehousing

Lilian Hobbs, Susan Hillson, Shilpa Lawande, Pete Smith
Expert Oracle Enterprise Manager 12c

Expert Oracle Enterprise Manager 12c

Kellyn Pot'vin, Anand Akela, Gokhan Atil, Bobby Curtis, Alex Gorbachev, Niall Litchfield, Leighton Nelson, Pete Sharman

Publisher Resources

ISBN: 9781555583354