Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> How Long to Update a table with 33 Million records
All,
I am just trying to find info on how long it will take to update a table with 33 million records .
This will be done on an E-15K SUN machine with massive processing power, running Oracle 9i on Solaris 8 or 9
How long will it take to do this update statement ..any estimates
Here are the details
(we don't have the database yet!).
However, we consider it to be something like:
Table
ID
DN (i.e. telephone number - 13 digitis)
Number of other columns
Flag (Y/N)
Indicies
A number of them on DN, and the other columes (assume 6)
Table size - 70 million records.
SQL Update Flag=Y Where DN=?????? Received on Fri Aug 15 2003 - 06:00:45 CDT
![]() |
![]() |