An optimization that automatically excludes partitions from a search when a query's conditions show they can't contain relevant data.
For example, if a table is partitioned by date and a query asks only for "this month's data," partitions for other months are skipped without being scanned at all. Reducing the amount of data scanned significantly improves query performance on large tables.
© 2026 ITBGM