Archives of the TeradataForum
Message Posted: Fri, 11 Dec 2009 @ 23:45:36 GMT
For views, we run a shell that generates a bunch of explain select * from
Then at the end of everything generate a select * from the volatile table. If you want detail errors, you can further do a explain select * just for those views and dump into a log file.
We don't have much proc and macros as part of app code ...
probably you can do an explain on the macro ddls and apply the same logic as before.
As far as SPs goes ... how about doing some alter
just my $0.02
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|