Archives of the TeradataForum
Message Posted: Mon, 26 Jan 2009 @ 15:29:52 GMT
We are converting a stored procedure from Sybase to Teradata that contains 20+ while loops and uses global temporary tables. We have found performance to vary dramatically based upon system activity even after allocating to a separate resource partition with a "rush" priority. Are there best practices for converting while loops? Would it be better to convert the looping logic into a bteq script? or individual stored procedure calls?
Thanks for any ideas.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|