Archives of the TeradataForum
Message Posted: Wed, 04 Aug 2010 @ 10:11:00 GMT
Yes, that sounds like a long time.
I think it's "back to basics" time:
- is the table evenly distributed across the AMPs ?
- are their any indexes on this column ?
- is this table perm journalled ?
- how busy is the system at the time it's running ?
I guess that you've changed the sql code to remove the tablename (that's fine), is the rest of the code 'real' ? No WHERE clauses removed - i.e. you're updating the entire table.
Double check that the table really only has 180k rows in it.
Ward Analytics Ltd: Information in motion (www.ward-analytics.com)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|