Archives of the TeradataForum

Message Posted: Fri, 26 Nov 1999 @ 02:36:34 GMT

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

Hi,

what is the best way to delete 4.5M records out of 805 M records from a multiset table with a 3-column primary index and 7 secondary index? It will take us days to do a straight delete from the table. Any suggestion is appreciated.

Cheers,

Glcbellon
Gemma Luisa C. Bellon
Vodafone Network Pty Ltd

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