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: Time to create index

Re: Time to create index

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Fri, 17 Jun 2005 21:51:42 +0200
Message-ID: <naa6b1dg24kti222d6e21redo3kkjc5krk@4ax.com> 





On Thu, 16 Jun 2005 19:53:07 +0200, "Matthias Hoys"
<idmwarpzone_NOSPAM__at_yahoo.com> wrote:




>

>If you have multiple processors, building the index with the PARALLEL option 

>can drastically improve performance ... 

>



And for the OP's information: it can also reduce performance if al the
data is on one disk.



Jaap.
Received on Fri Jun 17 2005 - 14:51:42 CDT












Original text of this message













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