Archives of the TeradataForum
Message Posted: Thu, 15 Apr 2010 @ 20:57:08 GMT
Vinay Bagare wrote:
If you are planning on doing a lot of these sort of imports via MS Excel/Access or any ODBC application you should be careful.
Each row inserted via OBCD will be treated as a single insert statement which will cause you two problems
1) Its going to take a very long time and tie up your PC for the day
2) More importantly is will cause skewing on DBC.AccLogTbl (view dbc.accessLog)
- the Primary Index of DBC.AccLogTbl is (LogonDate,LogonTime)
- every singly insert will have the same logonDate and LogonTime ==> every row will go to the same AMP and cause skewing of DBC.AccLogTbl and potentially cause dbc to run out of space.
|Copyright 2016 - All Rights Reserved
|Last Modified: 15 Jun 2023