opteryx icon indicating copy to clipboard operation
opteryx copied to clipboard

subquery projects aren't removed

Open joocer opened this issue 8 months ago • 0 comments

SELECT satellite_name FROM mission_reports
AFTER OPTIMIZATION
└─ EXIT
   └─ PROJECT [satellite_name]
      └─ PROJECT [satellite_name]
         └─ NESTED_INNER JOIN ($view-ba42.id = $view-a06f.planetId)
            ├─ READ ($satellites AS $view-a06f) [planetId, name]
            └─ READ ($planets AS $view-ba42) [id]

joocer avatar Mar 25 '25 21:03 joocer