|
|
Archives of the TeradataForum
Message Posted: Tue, 28 Oct 2003 @ 17:10:06 GMT
Subj: | | Re: Inserting Rows into tables with Secondary Indexes |
|
From: | | David Wellman |
Hi David,
I must admit that I haven't done any testing on this recently, but I'd have thought that only adding 20,000 rows to "tens of millions"
would definitely be a case for leaving the SI's in place. Even if running on a small system (20 amps or less) then you're only inserting
1,000 rows per amp - I've alays treated this sort of volume as trivial, in which case I just 'do it' (don't bother with any fancy
tricks).
Cheers,
Dave
| |