HomeMogDBMogDB StackUqbar
v5.0

Documentation:v5.0

Supported Versions:

Other Versions:

Dynamic Partition Pruning

Availability

This feature is available since MogDB 3.0.0.

Introduction

This feature mainly implements the following functions.

  1. Support NEST LOOP for partition pruning.

  2. Support bind variables for partition pruning.

  3. Support subqueries for partition pruning.

  4. Support using EXPLAIN ANALYZE to view the dynamic partition pruning results.

Benefits

This feature mainly optimizes the partition pruning feature, introduces dynamic partition pruning, and supports viewing partition pruning results by EXPLAIN ANALYZE. This feature improves the query performance of partitioned tables by pruning off the unneeded partitions and then scanning the partitioned tables during SQL execution.

Static Partition Pruning, Dynamic Partition Pruning

Copyright © 2011-2024 www.enmotech.com All rights reserved.