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 Refres h Options

8-6 Constraints

8-7 CAPABILITY_NAM E Column Details

8-8 MV_CAPABILITIES_TABLE Column Details

9-1 ROLLUP By Time and Product

15-1 ON DEMAND Refresh Methods

< a href="cdc.htm#g1029289">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 Contro l Columns for a Change Table

16-9 Effects of Publisher Adding a Column to a Change Table< /dd>

17-1 USER_WORKLOAD Table Format

17-2 Types of A dvisor Task Parameters And Their Uses

17-3 SQLAccess Advisor Action Attributes

< dd>17-4 SQLAccess Advisor Constants

18-1 Dimension and Constrai nt Requirements for Query Rewrite

18-2 View Constraints and Rewrite Integrity Modes

< dd>18-3 Partition Names and Their Pmarkers

20-1 Simple Cross-Tab ular Report With Subtotals

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

20-3 GROUPING SETS Statements and Equivalent GROUP BY

20-4 Hierarchica l CUBE Example

21-1 Analytic Functions and Their Uses

21-2 Common Diagnostic Statistics and Their Expressions

22-1 Ordered Rules< /a>

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 Fea tures