I am new to Teradata and was wondering if anyone can help me fix what I am doing to make my code more efficient:
I am creating a volitile table
CREATE VOLATILE TABLE Text
UNIQUE PRIMARY INDEX (ID)
ON COMMIT PRESERVE ROWS;
Then I am hitting import under the File selection and running
INSERT INTO Text
It is working but doing about 1000 rows every 5 minutes. I have 300,000 rows in the text file. Is there any way to improve my methods?
Assuming this is done using SQL Assistant, change the "Maximum batch size for simple imports" in Tools -> Option - Import to the maximum 999.