Archives of the TeradataForum

Message Posted: Tue, 02 Mar 2004 @ 10:30:14 GMT

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

Hi,

there is a third method for increasing the speed of your deletes... I bring that up because not everybody has the right to just replace the existing production table with a new table. I would guess most of us don't have those rights. And Mload might introduce other bottlenecks into your process.

You could create an interim table that only holds the data you need to delete. (Insert select into an empty table tends to be very quick).

The interim table should have the same structure, as the real production table that you want to delete from. But it's enough if your interim table carries all columns that you need to identify a row that is to be deleted.

You can than delete from your production table by joining on the interim table. This should guarantee PI access over full table scan, thus speeding things up :)

Hope this helps!

Mirjam

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