Archives of the TeradataForum
Message Posted: Tue, 14 May 2002 @ 14:11:33 GMT
I'm looking at exploiting V2R4 features - particularly aggregate indexes. Currently, we daily Mload into tables containing 25 months of data. Dropping and re-creating indexes nightly is probably not a viable option.
I'm looking for any of your experiences with the differences in run times between MLoads and TPump of tables with either join indexes or aggregate indexes on them.
We don't currently own TPump, so if any of you have any benchmark numbers I'd really appreciate any feedback you can give me.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|