What does this statement does diagnostic oldrewrites on for session??

Database
Enthusiast

What does this statement does diagnostic oldrewrites on for session??

What does this statement does

diagnostic oldrewrites on for session 

means??

2 REPLIES
Junior Contributor

Re: What does this statement does diagnostic oldrewrites on for session??

It's one of the undocmented diagnostic statements which are used by the Teradata developers to enable/disable specific features.

This one seems to switch off some newer optimizations, it's might be done to circumvent a bug until it's fixed in a patch.

Dieter

Enthusiast

Re: What does this statement does diagnostic oldrewrites on for session??

Thanks for the info...