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