Poor performance for nested includes #1634
Send to my agentKyleAMathews(GitHub profile, opens in a new tab) closed this
Sign in to join this conversation.
KyleAMathews(GitHub profile, opens in a new tab) closed this
Sign in to join this conversation.
We reproduced the reported nested shape and added a regression oracle and benchmark. The query creates the expected 260 nested materializations, with no duplicate or discarded facade construction. Nested includes increase work in proportion to the number of correlated queries they represent. We found no includes-specific amplification bug. Further speedups would be general query/materialization performance work and should be tracked separately.