Automatic Zone Maps

Automatic zone maps are created and maintained for any user table without any customer intervention. Zone maps allow the pruning of block ranges and partitions based on the predicates in the queries. Automatic zone maps are maintained for direct loads, and are maintained and refreshed for any other DML operation incrementally and periodically in the background.

Automatic zone maps improve the performance of queries transparently and automatically without management overhead.

Details: Automatic Zone Maps

This page provides more detailed information about the automatic zone map creation and maintenance.

Details: Automatic Zone Maps - Package

This page provides more detailed information about the new package related to automatic zone maps.

Details: Automatic Zone Maps - Views

This page provides more detailed information about the new package and views related to automatic zone maps.

Related Topics