tree 67341773dd90441f01701e6de24b81a3e5941543
parent fd0dcd290823c70d1d71fc32ebcd4fba6482dae9
author murali4104 <murali.krishna@couchbase.com> 1734720884 -0800
committer Peeyush Gupta <peeyush.gupta@couchbase.com> 1734735325 +0000

[ASTERIXDB-3496][COMP] Array Unnest Optimization

- user model changes: no
- storage format changes: no
- interface changes: no

Details:

Unnest Array operations are moved to more optimal locations in the plan
if possible. Think of Unnest Array ops as UDFs. A UDF can be very
expensive, so moving it to a place in the plan where the cardinality
is low is a good optimization. Similarly, when UNNEST ops are moved
above a join, the join gets less expensive as an UNNEST operation will
usually increase the cardinality and hence make the join more expensive.


Ext-ref: MB-64228

Change-Id: I103cdf840821a4c0c91cf3221f906cae75f053da
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/19209
Reviewed-by: Peeyush Gupta <peeyush.gupta@couchbase.com>
Tested-by: Peeyush Gupta <peeyush.gupta@couchbase.com>