asami

quoll 2022-03-10T20:51:26.984089Z

The plan is actually just a re-ordering of the constraints. They're then executed left-to-right

quoll 2022-03-10T20:52:47.957529Z

The ordering is based on the data, so if a particular constraint would return a large number of items, then it gets pushed back in the execution order. If it's a small result, then it's pulled to the front

quoll 2022-03-10T20:54:24.488839Z

So you want to cache based on transaction and query. Once you have that result, the query execution is lazy, and you can return as soon as the first lookup is done

simongray 2022-03-10T07:27:42.386039Z

Oh I see. So the plan can be returned independently and executed partially?