Importing a file from text

General

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?

1 REPLY
Junior Contributor

Re: Importing a file from text

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