Due to the syntax of left joins, you can't change the order: alias = JOIN left-alias BY left-alias-column [LEFT|RIGHT|FULL] [OUTER], right-alias BY right-alias-column [USING 'replicated' | 'skewed' | 'merge'] [PARTITION BY partitioner] [PARALLEL n];
…. so I assume the regular join optimizations don't apply here? I imagine this being defined as a 'regular' join … > Optimization for regular joins ensures that the last table in the join is > not brought into memory but streamed through instead. Optimization reduces > the amount of memory used which means you can avoid spilling the data and > also should be able to scale your query to larger data volumes. > To take advantage of this optimization, make sure that the table with the > largest number of tuples per key is the last table in your query. In some of > our tests we saw 10x performance improvement as the result of this > optimization. -- Founder/CEO Spinn3r.com Location: *San Francisco, CA* Skype: *burtonator* Skype-in: *(415) 871-0687*
