 |
 |
Archives of the TeradataForum
Message Posted: Tue, 12 Feb 2002 @ 21:37:50 GMT
| Subj: | | Re: Insert data into table |
| |
| From: | | Dieter N�th |
| | Our tables have only UPI. I deleted statistics because i need to know if the process is better or worse than tables with
statistics. | |
No need for statistics for an insert
| | This table have only a UPI | |
| | This sentence take around 50 minutes and insert only 300.000 rows app. | |
This is only ~100 inserts/sec
Do you have Sec. Indexes on the target table? If so, you can't drop/recreate them, because you only insert about 0.1% data, this would
be even slower.
Dieter
| |
