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

Time to create index

From: <amerar_at_iwc.net>
Date: 16 Jun 2005 08:10:11 -0700
Message-ID: <1118934611.036325.279930@g49g2000cwa.googlegroups.com> 






Hi,



Is there a way, based on the number of records in a table, to figure
out an estimate on how long it would take to create an index?



This table has about 4 million rows, and the index creation time took
almost 20 minutes.



Since we have a lot of large tables, I'd be curious if I can figure out
how long it would take to create the index.......



Thanks,



Arthur
Received on Thu Jun 16 2005 - 10:10:11 CDT












Original text of this message













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