Re: update statement PL/SQL

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Wed, 27 Apr 2005 21:15:30 -0700
Message-ID: <1114661491.917407@yasure>

pobox002_at_bebub.com wrote:

> Reallybig wrote:
>

>>I'm a newbie here.  I try to update data from 1 table from another
>>table.  So I used cursor to update my employee table on Total_sale
>>column  = amount column on Sales Table where employee.empid =
>>sales.empid.  The problem is for 700,000, it took 2 hours to update.
>>That's too long.  Any Ideas or some sample codes would really

>
> helpful.
>

>>Thanks

>
>
> Hopefully this is some kind of data warehouse, in which case you should
> look into materialized views.

Could you please explain how without any DDL or DML you can give this advice?

And then explain how this advice has anything to do with updating a table with 700,000 rows? It seems to me a materialized view is completely irrelevant but maybe I'm missing something.

Thanks.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Wed Apr 27 2005 - 23:15:30 CDT