Archives of the TeradataForum
Message Posted: Fri, 06 Apr 2007 @ 21:42:36 GMT
I need to load 60 million records daily into target table.
For loading these 60 million records I have to do some manipulation like 15 cast functions and 10 left outer joins.
So I'm trying to create a VOLATILE table in BTEQ and update the same table in BTEQ.
Hear my doubt is at performance point of view VOLATILE table is best or normal TABLE get good performance?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|