Re: Slow Update!!

jsfromynr wrote:
> Hello All,
>
> I am trying to update a table where based on some condition I am
> creating a group. For that matter I used the Minimum rowid of the group
> in the column minrowid.
>
> Update TableX X set minrowid =
> (
> Select min(rowid) from TableX Y where
> X.Name=Y.Name
> And X.City=Y.City
> )
>
> This table contains two or more rows for same combination of Name and
> City , so where clause is of no use.
>
> I was thiking of using a intermediate table as
>
> create table XYZ as
> Select min(rowid) minrowid,Name,City from TableX group by Name,City
>
>
> Then
> Update TableX X set minowid=(Select minrowid from XYZ Y where
> X.Name=Y.Name
> And X.City=Y.City
> )
>
> Will this Help!!!
>
> As I am running the statement in Procedure , ORacle does not allow me
> to create table
>
> Any Help is appreciated
>
> With warm regards
> Jatinder Singh

Before providing you with help can you explain what you are doing with the pseudocolumn rowid?

On its face it looks like a really bad idea.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org