List of Tables

5-1 Subpartition Mapping

5-2 Types of Partitioned Indexes

5-3 Comparing Prefixed Local, Nonprefixed Local, and Global Indexes

6-1 Sample Bitmap Index

6-2 Sample Bitmap Join Index

8-1 Schema Design Guidelines

8-2 Requirements for Materialized Views with Aggregates

8-3 Build Methods

8-4 Refresh Modes

8-5 Refresh Options

8-6 Constraints

8-7 CAPABILITY_NAME Column Details

8-8 MV_CAPABILITIES_TABLE Column Details

9-1 ROLLUP By Time and Product

15-1 ON DEMAND Refresh Methods

16-1 Summary of Change Sources and Change Sets

16-2 Views Intended for Use by Change Data Capture Publishers

16-3 Views Intended for Use by Change Data Capture Subscribers

16-4 Factors Influencing Choice of Change Data Capture Mode

16-5 Source Database Initialization Parameters for Asynchronous HotLog Publishing

16-6 Source Database Initialization Parameters for Asynchronous AutoLog Publishing

16-7 Staging Database Initialization Parameters for Asynchronous AutoLog Publishing

16-8 Control Columns for a Change Table

16-9 Effects of Publisher Adding a Column to a Change Table

17-1 USER_WORKLOAD Table Format

17-2 Types of Advisor Task Parameters And Their Uses

17-3 SQLAccess Advisor Action Attributes

17-4 SQLAccess Advisor Constants

18-1 Dimension and Constraint Requirements for Query Rewrite

18-2 View Constraints and Rewrite Integrity Modes

18-3 Partition Names and Their Pmarkers

20-1 Simple Cross-Tabular Report With Subtotals

20-2 GROUPING_ID Example for CUBE(a, b)

20-3 GROUPING SETS Statements and Equivalent GROUP BY

20-4 Hierarchical CUBE Example

21-1 Analytic Functions and Their Uses

21-2 Common Diagnostic Statistics and Their Expressions

22-1 Ordered Rules

24-1 Referential Integrity Restrictions

24-2 Parameters and Their Defaults

24-3 Parallelization Rules

24-4 Locks Acquired by Parallel DML Statements

24-5 Summary of INSERT Features