[maxvu]

Why, in the example, does the constituent `customerid` join take longer than the forming `orderid` one?

[icebraining]

You'd probably have to expand each step to see the specifics, but a simple possibility is that many customers don't have orders, and hence the first join filters out a bunch of them.