Query execution is slow in Teradata FastExport compared to Default Connection

413 Views Asked by At

I have a small doubt on how to use fastexport in production environment.

I have a million rows file and am using fastload to upload it to TD which is taking almost a minute and doing some business logic and when i use fastexport for downloading the table to my local machine/node, it is taking very long time compared to the default version.

Connection Uri i am using is :

jdbc:teradata://server/TMODE=ANSI,CHARSET=UTF8,TYPE=FASTEXPORT

Am i missing anything here. Please suggest.

Thanks

0

There are 0 best solutions below