Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Why would an Insert /*+ append */ be slower than a straight insert?

Re: Why would an Insert /*+ append */ be slower than a straight insert?

From: Jusung Yang <JusungYang_at_yahoo.com>
Date: 23 May 2003 19:05:59 -0700
Message-ID: <130ba93a.0305231805.2ff2c3ea@posting.google.com> 





Just a thought. You may not be comparing regular insert with direct
insert appropriately. You have the two different tables on two
different tablespaces, yes?  The right way to do it would be to use
the same table for both regular and direct insert and compare the
results. Whow knows what differences there are between the two tables
on the physical level. You can dig into it if you wish, but that's not
the right way to do any comparison, IMO.





Received on Fri May 23 2003 - 21:05:59 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US