[askdba] Re: Update
- From: "Justin Cave (DDBC)" <jcave@xxxxxxxxxxx>
- To: <askdba@xxxxxxxxxxxxx>
- Date: Mon, 18 Oct 2004 13:02:40 -0600
I'd strongly suggest adding the indexes, then. Otherwise, Oracle has to
do a lot more work to join the tables.
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:47 PM
To: askdba@xxxxxxxxxxxxx
Subject: [askdba] Re: Update
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?
>=20
> Are there indexes on the prov_id and suspect_id columns?
>=20
> Justin Cave <jcave@xxxxxxxxxxx>
> Distributed Database Consulting, Inc.
> http://www.ddbcinc.com/askDDBC
>=20
> -----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
>=20
> Is this the right syntax or there is a better way to update this. =
=3D20
> It's taking forever to update this table and there are only 45, 000
> rows in spy_panda_model_score
>=20
> update spy_panda_all_scores a
> set (rank_90_flat_period_1, rank_90_ref_period_1, paid_period_1)
=3D3D=3D20
> (select flat_90_rank, ref_90_rank, paid_total from
> spy_panda_model_score m where m.prov_id =3D3D a.suspect_id and
> m.score_period =3D3D '2003');
> commit;
>=20
> Thanks,
>=20
> Vu
>=20
>=20
--=20
Vu
Other related posts:
