Here's my attempt at documenting the optimizer overrides that are introduced by DERBY -573.
The documentation should say which overrides are associated with the FROM clause (joinOrder) and which with a TableExpression (everything else).
Also, there's a typo: "i t" instead of "it":
Important: Make sure that you adhere to the correct syntax when using the -- DERBY PROPERTIES clause. Failure to do so will cause the parser to interpret i t as a comment and ignore it.
[EMAIL PROTECTED]
Check out Swazoo Koolak's Web Jukebox at
http://swazoo.com/
