Re: Is there a way to dump all the plans considered by optimizer into log?

[Rick Hillegas]

I added an optional, trailing filename argument to the command which 
disables optimizer tracing. I linked the debugging tips wiki page to a 
new page which explains how to use the new commands which toggle 
optimizer tracing: http://wiki.apache.org/db-derby/OptimizerTracing

I also posed some questions about possible tracing improvements. See the 
attachment comment for derby-6022-07-aa-optimizerTracingWithLogFile.diff 
on https://issues.apache.org/jira/browse/DERBY-6022

Hope this is useful,
-Rick