-
Type:
Task
-
Resolution: Unresolved
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Optimization
-
None
-
None
-
None
-
None
-
None
-
None
-
None
There's some pipeline shapes visible in their tests, but I think we can also just run the compiler separately to investigate interesting SQL queries.
We could focus on how JOINs and subqueries, and other common SQL queries are translated.
Then we can determine if there are any pipeline shapes we need to support better with rewrites and analysis, for example to ensure JOO can apply, we can use an index, sort order, etc.
For example I can see a number of $replaceWith with $mergeObjects after $lookup:
{ "$replaceWith": { "$mergeObjects": ["$$ROOT", "$eca58228-b657-498a-b76e-f48a9161a404"] } }