4 ms·
Why, in the example, does the constituent `customerid` join take longer than the forming `orderid` one?
by maxvu 9y ago
Why, in the example, does the constituent `customerid` join take longer than the forming `orderid` one?
- icebraining 9y agoYou'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.