Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Should I use an /*+ append */ hint here???
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)
Sybrand Bakker, Senior Oracle DBA
To reply remove -verwijderdit from my e-mail address Received on Thu Feb 06 2003 - 23:14:48 CST