Re: Should I use an /*+ append */ hint here???

"Sybrand Bakker" <gooiditweg_at_nospam.demon.nl> wrote in message news:s1g64vglh957csgtq48ceki9co9umuaqiu_at_4ax.com...
> On Thu, 6 Feb 2003 19:59:05 -0500, "contrapositive"
> <contrapositive_at_hotmail.com> wrote:
>
> >So we're trying to optimize this. I'm wondering if an /*+ append */ hint
> >will speed things up. Is there any danger to using it? Also, if there's
data
> >loss, it's not a big deal (the data can be reconstructed pretty easily),
so
> >is there some logging feature we can turn off for this table? And how do
I
> >describe it to our DBA who says there isn't?
>
>
> Using the append hint will leave your indexes in invalid state and in
> need to be rebuild.
> Your DBA is right.
>
> You would better look into bulk inserts (depending on version, which
> no one mentions), as you are now inserting one record at a time, and
> using the array interface would speed things up more than fooling
> around with the redo log (unless the redolog isn't tuned, and unless
> you don't have your entire database on one disk)
>

Real quick, it's Oracle 8i... Received on Fri Feb 07 2003 - 04:39:28 CST