Support IndexMerge Intersection

[guo-shaoge]

Feature Request

Is your feature request related to a problem? Please describe:

None
Describe the feature you'd like:

We have IndexMergeUnion already, we now want IndexMergeIntersection. So different conditions connected by and can use multiple indexes.

In some situations, performance of IndexMergeIntersection is better than IndexLookUp and Selection + TableScan. For example, when you are sure the intersection of multiple indexes can filter most of data, IndexMergeIntersection is good to use.
Describe alternatives you've considered:

Teachability, Documentation, Adoption, Migration Strategy:

subtasks:

• planner part: Support IndexMerge Intersection (planner part) #39335
• executor part: Support IndexMerge Intersection (executor part) #39334
• telemetry: Add telemetry support for IndexMerge #39475