List of Examples

• 3-1        Creating a table with partition pruning
• 3-2        Partitioned table sales_range with attribute clustering and a zone map on a correlated column
• 3-3        Execution plan for partition pruning with zone maps
• 3-4        Querying with a full partition-wise join
• 3-5        Creating a table with range and interval partitioning
• 3-6        Creating a table with hash partitioning
• 3-7        Creating a table with list partitioning
• 3-8         Creating a table with composite range-hash partitioning
• 3-9        Creating a table with composite range-list partitioning
• 3-10      Creating a table with composite range-range partitioning
• 3-11      Creating a table with composite list-hash partitioning
• 3-12      Creating a table with composite list-list partitioning
• 3-13      Creating a table with composite list-range partitioning
• 3-14      Creating a table with virtual columns for partitioning
• 4-1        Creating a range-partitioned table
• 4-2        Creating a range-partitioned table with LOGGING and ENABLE ROW MOVEMENT
• 4-3        Creating a range-partitioned global index table
• 4-4        Creating a hash partitioned global index
• 4-5        Creating a list-partitioned table
• 4-6        Creating a list-partitioned table with a default partition
• 4-7        Creating an automatic list partitioned table
• 4-8        Creating a multicolumn list-partitioned table
• 4-9        Creating reference-partitioned tables
• 4-10      Creating a table with read-only and read-write partitions
• 4-11      Creating a Partitioned External Table
• 4-12      Creating a multicolumn range-partitioned table
• 4-13      Creating a range-partitioned table with a compressed partition
• 4-14      Creating a range-partitioned index-organized table
• 4-15      Creating a hash partitioned index-organized table
• 4-16      Creating a list-partitioned index-organized table
• 4-17      Creating a composite hash-hash partitioned table
• 4-18      Creating a composite interval-list partitioned table
• 4-19      Creating a composite interval-range partitioned table
• 4-20      Creating a composite list-hash partitioned table
• 4-21      Creating a composite list-list partitioned table
• 4-22      Creating a composite list-range partitioned table
• 4-23      Creating a composite range-hash partitioned table using one STORE IN clause
• 4-24      Creating a composite range-list partitioned table
• 4-25      Creating a range-hash partitioned table with a subpartition template
• 4-26      Creating a range-list partitioned table with a subpartition template
• 4-27      Using a filtering clause when performing maintenance operations
• 4-28      Adding partitions to a range-list partitioned table
• 4-29      Adding partitions to a range-range partitioned table
• 4-30      Using the FOR EXCHANGE WITH clause of CREATE TABLE
• 4-31      Exchanging a partition for a reference-partitioned table
• 4-32      Merging range partitions
• 4-33      Splitting a partition of a range-partitioned table and rebuilding indexes
• 4-34      Splitting a partition of a range-partitioned table online
• 4-35      Redefining partitions with collection tables
• 4-36      Using the MODIFY clause of ALTER TABLE to convert online to a partitioned table
• 5-1        Heat map views
• 5-2        Using DBMS_HEAT_MAP package subprograms
• 5-3        Creating a table with an ILM ADO policy
• 5-4        Adding ILM ADO policies
• 5-5        Disabling and deleting ILM ADO policies
• 5-6        Using segment-level compression and storage tiering
• 5-7        Creating an ADO policy using row-level Hybrid Columnar Compression
• 5-8        Creating an ADO policy using row-level advanced compression
• 5-9        Using CUSTOMIZE_ILM to customize ADO settings
• 5-10      Using In-Database Archiving
• 5-11      Creating a table with temporal validity
• 5-12      Manually implementing an ILM system
• 6-1        Creating a compressed partitioned materialized view
• 7-1        Creating a unique index and primary key constraint
• 8-1        Running an Explain Plan for a Query on Customers and Sales
• 8-2        Explain Plan Output for a Query on Customers and Sales
• 8-3        Using consumer groups to set priorities in the parallel statement queue
• 8-4        Explain Plan for UNION ALL
• 8-5        Parallelizing INSERT SELECT
• 8-6        Parallelizing UPDATE and DELETE
• 8-7        Parallelizing UPDATE and DELETE