Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.11
Description
There is a feature called "Partition Pruning" ( entry point:
prune_partitions()) where the optimizer figures out the set of
partitions it will need to read for a given table when running the
query.
One can see its result in "partitions" column in EXPLAIN PARTITIONS or
in EXPLAIN FORMAT=JSON.
Nothing is printed in the optimizer trace about this.
Attachments
Issue Links
- relates to
-
MDEV-21092 EXISTS to IN is not reflected in the optimizer trace
- Closed