I have worked through this issue. * When doing Join, please put the table with big number of rows containing the same join key to the rightmost in the JOIN clause. Otherwise we may see OutOfMemory errors.
This advice does work, but should we open up a jira to create a simple optimizer that does this? Edward
