On 10/26/2010 11:41 AM, Merlin Moncure wrote:
> yup, that's exactly what I mean -- this will give you more uniform
> insert performance (your temp table doesn't even need indexes). Every
> N records (say 10000) you send to permanent and truncate the temp
> table. Obviously, this is more fragile approach so weigh the
> pros/cons carefully.
>
> merlin
Truncate temporary table? What a horrible advice! All that you need is
the temporary table to delete rows on commit.
--
Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
http://www.vmsinfo.com
The Leader in Integrated Media Intelligence Solutions