Re: How Long to Update a table with 33 Million records

DOKNIK wrote:
> 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
>
> 1: SGA of the database is 6 Gb
> 2:Oracle Version is 9i
> 3: network data records, primary key = telephone number (the key of our
> file)
> 4: Rollback segments, as big or as small as we need!
>
>
> (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=??????
>

It might take Oracle a millisecond to any one of the 70 (or was it 33) million records, if you give him the primary key, unless the PK index would be terribly skewed.

What a strange question. I mean, I could do it myself, but not that fast.

Or did I get you wrong, and do you need to update 33 of the 70 million records? In that case, I would go about it in a different way.

GHP Received on Fri Aug 15 2003 - 06:46:51 CDT