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 an interval-partitioned table
• 4-5 Creating a hash partitioned global index
• 4-6 Creating a list-partitioned table
• 4-7 Creating a list-partitioned table with a default partition
• 4-8 Creating reference-partitioned tables
• 4-9 Creating a composite range-hash partitioned table using one STORE IN clause
• 4-10 Creating a composite range-list partitioned table
• 4-11 Creating a composite range-range partitioned table
• 4-12 Creating a composite list-hash partitioned table
• 4-13 Creating a composite list-list partitioned table
• 4-14 Creating a composite list-range partitioned table
• 4-15 Creating a composite interval-list partitioned table
• 4-16 Creating a composite interval-range partitioned table
• 4-17 Creating a range-hash partitioned table with a subpartition template
• 4-18 Creating a range-list partitioned table with a subpartition template
• 4-19 Creating a multicolumn range-partitioned table
• 4-20 Creating a table with a virtual column for the subpartitioning key
• 4-21 Creating a range-partitioned table with a compressed partition
• 4-22 Creating a range-partitioned index-organized table
• 4-23 Creating a hash partitioned index-organized table
• 4-24 Creating a list-partitioned index-organized table
• 4-25 Creating a nested table partition
• 4-26 Adding partitions to a range-list partitioned table
• 4-27 Adding partitions to a range-range partitioned table
• 4-28 Exchanging a partition for a reference-partitioned table
• 4-29 Merging range partitions
• 4-30 Redefining partitions with collection tables
• 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 Using row-level compression tiering
• 5-8 Using CUSTOMIZE_ILM to customize ADO settings
• 5-9 Using In-Database Archiving
• 5-10 Creating a table with temporal validity
• 5-11 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 Parallelization: Example 1
• 8-5 Parallelization: Example 2
• 8-6 Parallelization: Example 3
• 8-7 Explain Plan for UNION ALL
• 8-8 Parallelizing INSERT SELECT
• 8-9 Parallelizing UPDATE and DELETE
• 8-10 Parallelizing UPDATE and DELETE