Archives of the TeradataForum

Message Posted: Wed, 29 Sep 2004 @ 14:49:44 GMT

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

<-- Anonymously Posted: Wednesday, September 29, 2004 10:25 -->

My experience is if having one secondary takes x amount of additional time to load some data, having 2 secondaries for loading the same data approximately takes 2x amount additional time. If you already have the data regarding the overhead time due to 1 index use it. Otherwise you might want to create a secondary index (and collect the stat on it during your lean hours) and monitor the impact for couple of hours as it's always much easier to drop the index in almost no time. The queries shouldn't be impacted that badly. Estimate the index creation time from your past experience for your system.

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