Re: Insert /* +append */ always ?

From: Boaz Laufer <lauferb_at_adit-tec.com>
Date: 1 Jun 2002 04:37:07 -0700
Message-ID: <1bacd337.0206010337.7e8dee73@posting.google.com>

"R Chin" <rchin_at_panix.com> wrote in message news:<ab1l09$94b$1_at_reader1.panix.com>...
> Should I ALWAYS do
> Insert /* +append */ into select .....
> as opposed to
> Insert into select...... ???
>
> Under what circumstances should I NOT use the hint ?
>
> Thanks
>
> Rob

the thing is, INSERT with APPEND only inserts the rows AFTER THE HIGH WATER MARK!
This means that it doesn't use blocks that has data or had data in the past that was deleted! (even if there's enough space to add more rows) and this can cause a problem, especially if you delete the rows afterwards and than insert rows again. the old blocks wont be used and the table will get bigger and bigger...
(I had this exact problem at one of our customers!!!!)

Regards,
Boaz

---

Boaz Laufer.
Oracle DBA and Consultant.
Adit-Information Technologies.
Adanet business group. Received on Sat Jun 01 2002 - 06:37:07 CDT