Archives of the TeradataForum

Message Posted: Tue, 28 Oct 2003 @ 17:01:33 GMT

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

Has anyone done any testing to ascertain whether it's best to leave secondary indexes in place when inserting a significant number of rows into an existing table, or whether it's better to Drop and Re-create the index ?

Prior to V2R5 we were certainly of the opinion that the latter approach was better.

Unfortunately my testing appears very inconclusive and maybe suffering from varying loads on the box whilst my testing proceeds.

I'd be using an INSERT/SELECT approach with around 20,000 rows being added to a table of tens of millions.

Any clear conclusions that anyone's been able to derive would be useful.

Dave Clough
Database Designer
Database Design Group

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