Archives of the TeradataForum

Message Posted: Tue, 14 May 2002 @ 14:11:33 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi All,

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.

Thanks,

Ruth Fenwick
Hudson's Bay Company

	<Prev	Next>		<<First	<Prev	Next>	Last>>