Archives of the TeradataForum
Message Posted: Tue, 29 Oct 2002 @ 05:31:18 GMT
Hello Every one,
We wrote a stored procedure that uses a cursor to fill in numbers between two other numbers, for example From 1 to 6 ->
When using the cursor after a few hunderd thousand records the process slows down due to very large journal activity.
MY questions are:
1. Is there a way to insert all the records with out writing the tranactions to the journal?
2. Does any one have an Idea on how to do this with one SQL statment (or two as long as it is pure SQL)?
the table has the following fields:
And I want to Create a table that has these fields:
Thanks in Advance
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|