Archives of the TeradataForum

Message Posted: Wed, 29 Sep 2004 @ 13:58:40 GMT

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

<-- Anonymously Posted: Wednesday, September 29, 2004 09:12 -->

Hi,

We have had a request from some of our Business Users to add an extra secondary index to one of our larger tables.

The table is 460gb in size, and we load approx. 15m rows at day to it. Loads are done throughout the day every 2 hours.

The table has a partitioned primary index on date, and also has 1 existing secondary index. There is also one Hash Index (6gb) and one Join Index (200gb) on the table.

We know there will be an overhead to adding another secondary index, but is it possible to estimate what this might be? Obviously, our ideal would be to copy the table, or even half of it, add the index and test both user queries and loads (we are worried our loads may slow down considerably), however, we do not have sufficient space on our system to do this at present.

Is there any other way of determing the impact?

Many thanks.

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