Handling stray values in a LIST or RANGE partitioned table v17

Suggest edits

A DEFAULT or MAXVALUE partition or subpartition captures any rows that don't meet the other partitioning rules defined for a table.

Defining a DEFAULT partition

Defining a MAXVALUE partition

← Prev

Example: Partition pruning

↑ Up

Using table partitioning

Next →

Defining a DEFAULT partition