Archives of the TeradataForum
Message Posted: Mon, 08 Apr 2013 @ 20:08:42 GMT
I have experienced a similar issue (with queries involving many many nested views).
This was identified as a Teradata bug with a temporary workaround advised of setting
"DIAGNOSTIC NOVIEWFOLD ON FOR SESSION;"
Try running the above and then see if this improves the Explain time.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|