The biggest impact that you can have on the use of your derived table is to place the join column as the first column, since that is
the implied primary index. It can save potential redistribution in order to do a subsequent join.
Sounds interesting, do you have an example (explain) for that?
