All Forums General
wactuary 1 post Joined 02/15
03 Feb 2015
Importing a file from text

Hello everyone,
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
(
ID CHAR(9)
 
)
UNIQUE PRIMARY INDEX (ID)
ON COMMIT PRESERVE ROWS;
Then I am hitting import under the File selection and running
INSERT INTO Text
VALUES (?);
 
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?
 
 
 

dnoeth 4628 posts Joined 11/04
04 Feb 2015

Assuming this is done using SQL Assistant, change the "Maximum batch size for simple imports" in Tools -> Option - Import to the  maximum 999.

Dieter

You must sign in to leave a comment.