← Questions
Rewrite a SQL query plan tree
0
I was asked this
No reports yet. Sign in to say where you were asked it.
A query plan is a tree of scan, filter, project and join nodes. Write rewrite rules that make it cheaper, such as moving a filter beneath a join, while the new plan still returns exactly the same rows.
No official answer yet. Write yours on the right and run it.
Nothing published yet.
Sign in to submit your code; every attempt is kept here.
Write and test your solution herePython in your browser, the question's tests level by level, every submission kept for you.Sign in to start coding