[askdba] Re: Update
- From: "Justin Cave (DDBC)" <jcave@xxxxxxxxxxx>
- To: <askdba@xxxxxxxxxxxxx>
- Date: Mon, 18 Oct 2004 12:37:03 -0600
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
Other related posts:
