[askdba] Re: Update
- From: VuCanDo <vuquyen@xxxxxxxxx>
- To: askdba@xxxxxxxxxxxxx
- Date: Mon, 18 Oct 2004 15:53:54 -0700
yes, analyst both tables and indexes. Oracle 9.2.0.5. Full scan
spy_panda_all_scores and use index for spy_panda_model_score
(score_period)
On Mon, 18 Oct 2004 21:43:12 +0100, Regis Biassala
<regis.biassala@xxxxxxxxxx> wrote:
> Did u analyze your tables and indexes ?
> Oracle what version please ?
> Explain of the update please ?
>
> Regis
>
>
>
> -----Original Message-----
> From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx] On
> Behalf Of VuCanDo
> Sent: 18 October 2004 21:29
> To: askdba@xxxxxxxxxxxxx
> Subject: [askdba] Re: Update
>
> I added 2 indexes for both tables, prov_id and suspect_id and it's
> still running.....something much go wrong .....
>
> On Mon, 18 Oct 2004 13:02:40 -0600, Justin Cave (DDBC)
> <jcave@xxxxxxxxxxx> wrote:
> > 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
> >
> >
>
> --
> Vu
>
>
--
Vu
Other related posts:
