[askdba] Re: Update
- From: VuCanDo <vuquyen@xxxxxxxxx>
- To: askdba@xxxxxxxxxxxxx
- Date: Mon, 18 Oct 2004 11:47:29 -0700
None of indexes right now. All 45,000 rows in the table need to be update....
On Mon, 18 Oct 2004 12:37:03 -0600, Justin Cave (DDBC)
<jcave@xxxxxxxxxxx> wrote:
> How many rows are being updated in spy_panda_all_scores?
>
> Are there indexes on the prov_id and suspect_id columns?
>
> Justin Cave <jcave@xxxxxxxxxxx>
> Distributed Database Consulting, Inc.
> http://www.ddbcinc.com/askDDBC
>
> -----Original Message-----
> From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx]
> On Behalf Of VuCanDo
> Sent: Monday, October 18, 2004 2:28 PM
> To: ASKDBA
> Subject: [askdba] Update
>
> Is this the right syntax or there is a better way to update this. =20
> It's taking forever to update this table and there are only 45, 000
> rows in spy_panda_model_score
>
> update spy_panda_all_scores a
> set (rank_90_flat_period_1, rank_90_ref_period_1, paid_period_1) =3D=20
> (select flat_90_rank, ref_90_rank, paid_total from
> spy_panda_model_score m where m.prov_id =3D a.suspect_id and
> m.score_period =3D '2003');
> commit;
>
> Thanks,
>
> Vu
>
>
--
Vu
Other related posts:
