Archives of the TeradataForum
Message Posted: Mon, 01 Mar 2004 @ 17:47:59 GMT
You probably should get rid of the NUSI, with a table that size it's doubtful the nusi would ever be selective enough to be used by the optimizer. When we dropped 2 of the 3 nusi's on a 2 billion row table our load rate went up by a factor of 3 (using multiload).
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|