Archives of the TeradataForum

Message Posted: Mon, 04 Nov 2002 @ 19:14:48 GMT

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

Hi,

The secondary index in question on average have 10 base values to each index value, with a min and max of 1 and 100 respectively.

We have tried seondary indexes which have 000's of base values per index value, and in most cases, they were not used, so we ruled them out.

At present we would just like to be able to use one secondary index and not see such a degradation in performance.

For the people using TPump as their load mechanism. Do you use secondary indexes on your large tables, if so what is the performance like.

Regards

Matthew Winter

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