Archives of the TeradataForum
Message Posted: Fri, 18 May 2001 @ 15:01:05 GMT
Which columns define the primary index? Do you have any information if L,M,N is skewed?
For an insert/select you need only one session. More than one session will produce a better performance by Bteq imports and exports.
If it is you (your user) only running this query, you might look for hot amps by
If the differences are to big this will be an indication for skewing for the data (L,M,N).
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|