Re: Enabling optimizer trace

[Rick Hillegas]

Satheesh Bandaram wrote:

Hi Mamta,
Thanks for trying to get optimizer trace working... I think this is a 
useful tool, though it might generate lots of information. Unwanted 
information can be filtered out easily, so I would enable this as is. 
Any other improvements can be taken up later.

Current diagnostic properties like DumpOptimizedTree also print huge 
amount of information. It would be nice to be able to control level of 
detail being generated.

For all of our diagnostic output, there's probably a big payoff in 
moving to some more structured format like xml. That will help 
client-side (and even off-the-shelf) tools format the output and filter 
out unwanted information.